Product: | AMS - Marketing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AMS_DS_ORDERS_V |
SELECT OH.ORG_ID
, OH.SOLD_TO_ORG_ID
, CUST.PARTY_ID
, OH.ORDERED_DATE
, OH.TRANSACTIONAL_CURR_CODE
, OH.SOLD_FROM_ORG_ID
, OH.SALES_CHANNEL_CODE
, OH.BOOKED_DATE
, OH.MARKETING_SOURCE_CODE_ID
, OL.LINE_ID
, OL.HEADER_ID
, OL.LINE_CATEGORY_CODE
, OL.LINE_NUMBER
, OL.ORDER_QUANTITY_UOM
, OL.ORDERED_QUANTITY
, MSI.SEGMENT1 ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, OL.UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, OL.UNIT_LIST_PRICE UNIT_LIST_PRICE
, NVL(OL.UNIT_SELLING_PRICE
, 0)*( NVL(OL.ORDERED_QUANTITY
, 0) - NVL(OL.CANCELLED_QUANTITY
, 0) ) EXTENDED_PRICE
, OL.SCHEDULE_SHIP_DATE
, OL.SCHEDULE_ARRIVAL_DATE
, OL.ACTUAL_SHIPMENT_DATE
, OL.ACTUAL_ARRIVAL_DATE
, OL.SHIPPED_QUANTITY
, OL.SHIP_TO_CONTACT_ID
, OL.CANCELLED_FLAG
, OL.OPEN_FLAG
, OL.BOOKED_FLAG
, OL.OPTION_NUMBER
, OL.SHIPPING_QUANTITY_UOM
, OL.CANCELLED_QUANTITY
, OL.PROMISE_DATE
, OL.REQUEST_DATE
, OL.SHIPPING_METHOD_CODE
, OL.SHIPMENT_PRIORITY_CODE
, OL.LINE_TYPE_ID
, OL.PRICING_QUANTITY
, OL.PRICING_QUANTITY_UOM
, OL.FULFILLED_QUANTITY
, OL.SHIPPING_QUANTITY
, OL.ORDER_SOURCE_ID
, OL.INVOICE_TO_ORG_ID
, OL.SHIP_TO_ORG_ID
, OL.ATO_LINE_ID
, OL.CREATION_DATE
, OL.LAST_UPDATE_DATE
, ' '
, MSI.CONCATENATED_SEGMENTS
, ' '
, MSI.INVENTORY_ITEM_ID
, OH.ATTRIBUTE1
, OH.ATTRIBUTE2
, OH.ATTRIBUTE3
, OH.ATTRIBUTE4
, OH.ATTRIBUTE5
, OH.ATTRIBUTE6
, OH.ATTRIBUTE7
, OH.ATTRIBUTE8
, OH.ATTRIBUTE9
, OH.ATTRIBUTE10
, OH.ATTRIBUTE11
, OH.ATTRIBUTE12
, OH.ATTRIBUTE13
, OH.ATTRIBUTE14
, OH.ATTRIBUTE15
, OH.ATTRIBUTE16
, OH.ATTRIBUTE17
, OH.ATTRIBUTE18
, OH.ATTRIBUTE19
, OH.ATTRIBUTE20
FROM OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
, MTL_SYSTEM_ITEMS_VL MSI
, HZ_CUST_ACCOUNTS CUST
WHERE OL.HEADER_ID = OH.HEADER_ID
AND OL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = OL.ORG_ID
AND CUST.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID