1. Tables and Views for SCM
  2. CMR_XLA_ASN_INTRANSIT_AMTS_V

CMR_XLA_ASN_INTRANSIT_AMTS_V

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: VIEW

Columns

Name

ASN_INTRANSIT_ID

SHIPMENT_LINE_ID

PO_LINE_LOCATION_ID

PO_LINE_CURRENCY_CODE

BILL_TO_BUSINESS_UNIT_ID

BUSINESS_UNIT_ID

INVENTORY_ORG_ID

DESTINATION_TYPE_CODE

VENDOR_ID

VENDOR_TYPE

VENDOR_NAME

PO_NUMBER

PO_PRICE

TRANSACTION_TYPE

FOB_LOOKUP_CODE

ASN_ATTRIBUTE1

ASN_ATTRIBUTE2

ASN_ATTRIBUTE3

ASN_ATTRIBUTE4

ASN_ATTRIBUTE5

ASN_ATTRIBUTE6

ASN_ATTRIBUTE7

ASN_ATTRIBUTE8

ASN_ATTRIBUTE9

ASN_ATTRIBUTE10

ASN_ATTRIBUTE11

ASN_ATTRIBUTE12

ASN_ATTRIBUTE13

ASN_ATTRIBUTE14

ASN_ATTRIBUTE15

ASN_ATTRIBUTE16

ASN_ATTRIBUTE17

ASN_ATTRIBUTE18

ASN_ATTRIBUTE19

ASN_ATTRIBUTE20

Query

SQL_Statement

SELECT /*+ NO_MERGE */

caia.asn_intransit_id asn_intransit_id,

caia.shipment_line_id shipment_line_id,

caia.po_line_location_id po_line_location_id,

caia.currency_code po_line_currency_code,

caia.bill_to_business_unit_id bill_to_business_unit_id,

caia.business_unit_id business_unit_id,

caia.inventory_org_id inventory_org_id,

caia.destination_type_code destination_type_code,

caia.vendor_id vendor_id,

ps.vendor_type_lookup_code vendor_type,

ps.vendor_name vendor_name,

caia.po_number po_number,

caia.po_price po_price,

caia.transaction_type transaction_type,

caia.fob_lookup_code fob_lookup_code,

rsl.attribute1 asn_attribute1,

rsl.attribute2 asn_attribute2,

rsl.attribute3 asn_attribute3,

rsl.attribute4 asn_attribute4,

rsl.attribute5 asn_attribute5,

rsl.attribute6 asn_attribute6,

rsl.attribute7 asn_attribute7,

rsl.attribute8 asn_attribute8,

rsl.attribute9 asn_attribute9,

rsl.attribute10 asn_attribute10,

rsl.attribute11 asn_attribute11,

rsl.attribute12 asn_attribute12,

rsl.attribute13 asn_attribute13,

rsl.attribute14 asn_attribute14,

rsl.attribute15 asn_attribute15,

rsl.attribute16 asn_attribute16,

rsl.attribute17 asn_attribute17,

rsl.attribute18 asn_attribute18,

rsl.attribute19 asn_attribute19,

rsl.attribute20 asn_attribute20

FROM

cmr_asn_intransit_amts caia,

rcv_shipment_lines rsl,

poz_suppliers_v ps

WHERE

caia.vendor_id = ps.vendor_id

AND caia.shipment_line_id = rsl.shipment_line_id