View: OEFV_SALES_ORDER_LINES

View Text

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.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
, '_DF:OE:SO_LINES:LINE'
, '_DF:OE:PRICING_ATTRIBUTES:LINE'
, '_DF:OE:INDUSTRY_ATTRIBUTES:ATTR'
, '_DF:JG:JG_SO_LINE_ATTRIBUTES:ATTR'
, HEADER.ORDER_NUMBER
, '_KF:INV:MSTK:ITEM'
, PARA.ORGANIZATION_CODE
, ORG.NAME
, PARA2.ORGANIZATION_CODE
, ORG2.NAME
, PRICE_LIST.NAME
, AGREEMENT.NAME
, UOM.UNIT_OF_MEASURE
, PAYTERMS.NAME
, CUSTRX.TRX_NUMBER
, OPTION_PARENT.LINE_NUMBER
, MODEL.LINE_NUMBER
, SERVICE.LINE_NUMBER
, CYCLE.NAME
, SITE.LOCATION
, CONTACT.FIRST_NAME||' '||CONTACT.LAST_NAME
, INTERMEDIATE_SITE.LOCATION
, IRULE.NAME
, ARULE.NAME
, REQ.LINE_NUM
, PROJ.NAME
, PROJTASK.TASK_NUMBER
, LINE.LINE_ID
, LINE.HEADER_ID
, LINE.INVENTORY_ITEM_ID
, LINE.WAREHOUSE_ID
, LINE.ORG_ID /* OPERATING_UNIT_ID */
, LINE.PRICE_LIST_ID
, LINE.AGREEMENT_ID
, LINE.UNIT_CODE
, LINE.TERMS_ID
, LINE.COMMITMENT_ID
, LINE.LINK_TO_LINE_ID /* OPTION_PARENT_LINE_ID */
, LINE.PARENT_LINE_ID /* MODEL_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_LINE_ATTRIBUTES ATTR
, SO_HEADERS_ALL HEADER
, MTL_PARAMETERS PARA
, MTL_PARAMETERS PARA2
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS ORG2
, MTL_SYSTEM_ITEMS ITEM
, SO_CYCLES CYCLE
, SO_AGREEMENTS AGREEMENT
, MTL_UNITS_OF_MEASURE UOM
, RA_SITE_USES_ALL SITE
, RA_SITE_USES_ALL INTERMEDIATE_SITE
, RA_RULES IRULE
, RA_RULES ARULE
, RA_TERMS PAYTERMS
, RA_CONTACTS CONTACT
, RA_CUSTOMER_TRX_ALL CUSTRX
, SO_PRICE_LISTS PRICE_LIST
, SO_LINES_ALL OPTION_PARENT
, SO_LINES_ALL MODEL
, SO_LINES_ALL SERVICE
, PO_REQUISITION_LINES_ALL REQ
, PA_PROJECTS_ALL PROJ
, PA_TASKS PROJTASK
WHERE LINE.HEADER_ID = HEADER.HEADER_ID
AND LINE.LINE_TYPE_CODE != 'DETAIL'
AND LINE.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID
AND NVL(LINE.WAREHOUSE_ID
, FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID')) = ITEM.ORGANIZATION_ID
AND PARA.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND LINE.LINE_ID = ATTR.LINE_ID(+)
AND LINE.ORG_ID = PARA2.ORGANIZATION_ID(+)
AND LINE.ORG_ID = ORG2.ORGANIZATION_ID(+)
AND LINE.PRICE_LIST_ID = PRICE_LIST.PRICE_LIST_ID(+)
AND LINE.AGREEMENT_ID = AGREEMENT.AGREEMENT_ID(+)
AND LINE.UNIT_CODE = UOM.UNIT_OF_MEASURE(+)
AND LINE.TERMS_ID = PAYTERMS.TERM_ID(+)
AND LINE.LINK_TO_LINE_ID = OPTION_PARENT.LINE_ID(+)
AND LINE.PARENT_LINE_ID = MODEL.LINE_ID(+)
AND LINE.SERVICE_PARENT_LINE_ID = SERVICE.LINE_ID(+)
AND LINE.CYCLE_ID = CYCLE.CYCLE_ID(+)
AND LINE.SHIP_TO_SITE_USE_ID = SITE.SITE_USE_ID(+)
AND LINE.INTERMEDIATE_SHIP_TO_ID = INTERMEDIATE_SITE.SITE_USE_ID(+)
AND LINE.INVOICING_RULE_ID = IRULE.RULE_ID(+)
AND LINE.ACCOUNTING_RULE_ID = ARULE.RULE_ID(+)
AND LINE.SHIP_TO_CONTACT_ID = CONTACT.CONTACT_ID(+)
AND LINE.COMMITMENT_ID = CUSTRX.CUSTOMER_TRX_ID(+)
AND LINE.ORIGINAL_SYSTEM_LINE_REFERENCE = REQ.REQUISITION_LINE_ID(+)
AND LINE.PROJECT_ID = PROJ.PROJECT_ID(+)
AND LINE.TASK_ID = PROJTASK.TASK_ID(+) WITH READ ONLY

Columns