Product: | AMS - Marketing |
---|---|
Description: | Order Lines |
Implementation/DBA Data: | Not implemented in this database |
SELECT OL. LINE_ID
, OL.HEADER_ID
, OL.LINE_TYPE_ID
, OL.LINE_NUMBER
, OL.ORDERED_ITEM
, OL.REQUEST_DATE
, OL.PROMISE_DATE
, OL.SCHEDULE_SHIP_DATE
, OL.ORDER_QUANTITY_UOM
, OL.PRICING_QUANTITY
, OL.PRICING_QUANTITY_UOM
, OL.CANCELLED_QUANTITY
, OL.SHIPPED_QUANTITY
, OL.ORDERED_QUANTITY
, OL.FULFILLED_QUANTITY
, OL.SHIPPING_QUANTITY
, OL.SHIPPING_QUANTITY_UOM
, OL.DELIVERY_LEAD_TIME
, OL.TAX_EXEMPT_FLAG
, OL.TAX_EXEMPT_NUMBER
, OL.TAX_EXEMPT_REASON_CODE
, OL.SHIP_FROM_ORG_ID
, OL.SHIP_TO_ORG_ID
, OL.INVOICE_TO_ORG_ID
, OL.DELIVER_TO_ORG_ID
, OL.SHIP_TO_CONTACT_ID
, OL.DELIVER_TO_CONTACT_ID
, OL.INVOICE_TO_CONTACT_ID
, OL.SOLD_TO_ORG_ID
, OL.CUST_PO_NUMBER
, OL.SHIP_TOLERANCE_ABOVE
, OL.SHIP_TOLERANCE_BELOW
, OL.DEMAND_BUCKET_TYPE_CODE
, OL.RLA_SCHEDULE_TYPE_CODE
, OL.CUSTOMER_DOCK_CODE
, OL.CUSTOMER_JOB
, OL.CUSTOMER_PRODUCTION_LINE
, OL.CUST_MODEL_SERIAL_NUMBER
, OL.PROJECT_ID
, OL.TASK_ID
, OL.INVENTORY_ITEM_ID
, IT.SEGMENT1 ITEM_NAME
, IT.DESCRIPTION ITEM_DESCRIPTION
, OL.TAX_DATE
, OL.TAX_CODE
, OL.TAX_RATE
, OL.DEMAND_CLASS_CODE
, OL.PRICE_LIST_ID
, OL.PRICING_DATE
, OL.SHIPMENT_NUMBER
, OL.AGREEMENT_ID
, OL.SHIPMENT_PRIORITY_CODE
, OL.SHIPPING_METHOD_CODE
, OL.FREIGHT_CARRIER_CODE
, OL.FREIGHT_TERMS_CODE
, OL.FOB_POINT_CODE
, OL.TAX_POINT_CODE
, OL.PAYMENT_TERM_ID
, OL.INVOICING_RULE_ID
, OL.ACCOUNTING_RULE_ID
, OL.SOURCE_DOCUMENT_TYPE_ID
, OL.ORIG_SYS_DOCUMENT_REF
, OL.SOURCE_DOCUMENT_ID
, OL.ORIG_SYS_LINE_REF
, OL.SOURCE_DOCUMENT_LINE_ID
, OL.REFERENCE_LINE_ID
, OL.REFERENCE_TYPE
, OL.REFERENCE_HEADER_ID
, OL.ITEM_REVISION
, OL.UNIT_SELLING_PRICE
, OL.UNIT_LIST_PRICE
, OL.TAX_VALUE
, OL.CONFIGURATION_ID
, OL.LINK_TO_LINE_ID
, OL.COMPONENT_SEQUENCE_ID
, OL.COMPONENT_CODE
, OL.CONFIG_DISPLAY_SEQUENCE
, OL.SORT_ORDER
, OL.ITEM_TYPE_CODE
, OL.OPTION_NUMBER
, OL.OPTION_FLAG
, OL.DEP_PLAN_REQUIRED_FLAG
, OL.VISIBLE_DEMAND_FLAG
, OL.LINE_CATEGORY_CODE
, OL.ACTUAL_SHIPMENT_DATE
, OL.CUSTOMER_TRX_LINE_ID
, OL.INTMED_SHIP_TO_ORG_ID
, OL.INTMED_SHIP_TO_CONTACT_ID
, OL.ACTUAL_ARRIVAL_DATE
, OL.ATO_LINE_ID
, OL.AUTO_SELECTED_QUANTITY
, OL.COMPONENT_NUMBER
, OL.EARLIEST_ACCEPTABLE_DATE
, OL.EXPLOSION_DATE
, OL.LATEST_ACCEPTABLE_DATE
, OL.MODEL_GROUP_NUMBER
, OL.SCHEDULE_ARRIVAL_DATE
, OL.SHIP_MODEL_COMPLETE_FLAG
, OL.SCHEDULE_STATUS_CODE
, OL.SOURCE_TYPE_CODE
, OL.TOP_MODEL_LINE_ID
, OL.BOOKED_FLAG
, OL.CANCELLED_FLAG
, OL.OPEN_FLAG
, OL.SALESREP_ID
, OL.RETURN_REASON_CODE
, OL.ARRIVAL_SET_ID
, OL.SHIP_SET_ID
, OL.INVOICE_INTERFACE_STATUS_CODE
, OL.SPLIT_FROM_LINE_ID
, OL.CUST_PRODUCTION_SEQ_NUM
, OL.AUTHORIZED_TO_SHIP_FLAG
, OL.VEH_CUS_ITEM_CUM_KEY_ID
, OL.OVER_SHIP_REASON_CODE
, OL.OVER_SHIP_RESOLVED_FLAG
, OL.ITEM_IDENTIFIER_TYPE
, OL.COMMITMENT_ID
, OL.SHIPPING_INTERFACED_FLAG
, OL.CREDIT_INVOICE_LINE_ID
, OL.FIRST_ACK_CODE
, OL.FIRST_ACK_DATE
, OL.LAST_ACK_CODE
, OL.LAST_ACK_DATE
, OL.PLANNING_PRIORITY
, OL.CONFIG_HEADER_ID
, OL.CONFIG_REV_NBR
, OL.SOLD_FROM_ORG_ID
, OL.FULFILLED_FLAG
, OL.END_ITEM_UNIT_NUMBER
, OL.SHIPPING_INSTRUCTIONS
, OL.PACKING_INSTRUCTIONS
, OL.INVOICED_QUANTITY
, OL.REFERENCE_CUSTOMER_TRX_LINE_ID
, OL.SERVICE_TXN_REASON_CODE
, OL.SERVICE_TXN_COMMENTS
, OL.SERVICE_DURATION
, OL.SERVICE_START_DATE
, OL.SERVICE_END_DATE
, OL.SERVICE_COTERMINATE_FLAG
, OL.UNIT_LIST_PERCENT
, OL.UNIT_SELLING_PERCENT
, OL.UNIT_PERCENT_BASE_PRICE
, OL.SERVICE_NUMBER
, OL.SERVICE_REFERENCE_TYPE_CODE
, OL.SERVICE_REFERENCE_LINE_ID
, OL.SERVICE_REFERENCE_SYSTEM_ID
, OL.MARKETING_SOURCE_CODE_ID
, OL.FLOW_STATUS_CODE
, OL.MODEL_REMNANT_FLAG
, OL.FULFILLMENT_METHOD_CODE
, OL.ORDERED_ITEM_ID
, OL.ORG_ID
FROM OE_ORDER_LINES OL
, MTL_SYSTEM_ITEMS_VL IT
WHERE OL.INVENTORY_ITEM_ID = IT.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = OE_PROFILE.VALUE('OE_ORGANIZATION_ID'
, OL.ORG_ID)