Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT LINE.LINE_NUMBER
, LINE.PROMISE_DATE
, '_LA:LINE.SHIPMENT_PRIORITY_CODE:SO_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, '_LA:LINE.SHIP_METHOD_CODE:SO_LOOKUPS:SHIPPING_METHOD:MEANING'
, LINE.INVOICED_QUANTITY
, LINE.REVENUE_AMOUNT
, LINE.TAX_EXEMPT_NUMBER
, '_LA:LINE.TAX_EXEMPT_REASON_CODE:AR_LOOKUPS:TAX_REASON:MEANING'
, LINE.ORIGINAL_SYSTEM_LINE_REFERENCE
, '_LA:LINE.OPEN_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.ITEM_TYPE_CODE:SO_LOOKUPS:ITEM TYPE:MEANING'
, '_LA:LINE.ATO_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.SHIP_MODEL_COMPLETE_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, LINE.DATE_REQUESTED_CURRENT
, LINE.ORDERED_QUANTITY
, LINE.CANCELLED_QUANTITY
, LINE.SELLING_PRICE
, LINE.SCHEDULE_DATE
, LINE.SHIP_SET_NUMBER
, LINE.SHIPPED_QUANTITY
, LINE.CUSTOMER_JOB
, LINE.CUSTOMER_PRODUCTION_LINE
, LINE.CUSTOMER_MODEL_SERIAL_NUMBER
, LINE.CUSTOMER_DOCK_CODE
, LINE.PLANNING_PROD_SEQ_NUMBER
, LINE.LATEST_ACCEPTABLE_DATE
, '_LA:LINE.SOURCE_TYPE_CODE:SO_LOOKUPS:SOURCE TYPE:MEANING'
, LINE.PLANNING_PRIORITY
, '_LA:LINE.DEMAND_CLASS_CODE:FND_COMMON_LOOKUPS:DEMAND_CLASS:MEANING'
, '_DF:OE:SO_LINES:LINE'
, '_DF:OE:PRICING_ATTRIBUTES:LINE'
, '_DF:OE:INDUSTRY_ATTRIBUTES:ATTR'
, '_DF:JG:JG_SO_LINE_ATTRIBUTES:ATTR'
, LINE.LINE_ID
, LINE.HEADER_ID
, LINE.INVENTORY_ITEM_ID
, LINE.WAREHOUSE_ID
, LINE.ORG_ID
, LINE.PRICE_LIST_ID
, LINE.AGREEMENT_ID
, LINE.UNIT_CODE
, LINE.TERMS_ID
, LINE.COMMITMENT_ID
, LINE.LINK_TO_LINE_ID
, LINE.PARENT_LINE_ID
, LINE.SERVICE_PARENT_LINE_ID
, LINE.CYCLE_ID
, LINE.SHIP_TO_SITE_USE_ID
, LINE.SHIP_TO_CONTACT_ID
, LINE.INTERMEDIATE_SHIP_TO_ID
, LINE.INVOICING_RULE_ID
, LINE.ACCOUNTING_RULE_ID
, DECODE(HEADER.ORDER_CATEGORY
, 'P'
, LINE.ORIGINAL_SYSTEM_LINE_REFERENCE
, NULL)
, LINE.PROJECT_ID
, LINE.TASK_ID
, LINE.LAST_UPDATE_DATE
, LINE.LAST_UPDATED_BY
, LINE.CREATION_DATE
, LINE.CREATED_BY
FROM SO_LINES_ALL LINE
, SO_HEADERS_ALL HEADER
, SO_LINE_ATTRIBUTES ATTR
WHERE LINE.HEADER_ID = HEADER.HEADER_ID
AND LINE.LINE_TYPE_CODE != 'DETAIL'
AND LINE.LINE_ID = ATTR.LINE_ID(+) WITH READ ONLY