View: SO_LINES_OEXORRSO_V

View Text

SELECT LIN.ROWID ROW_ID
, LIN.LINE_ID
, LIN.CREATION_DATE
, LIN.CREATED_BY
, LIN.LAST_UPDATE_DATE
, LIN.LAST_UPDATED_BY
, LIN.LAST_UPDATE_LOGIN
, LIN.REQUEST_ID
, LIN.PROGRAM_APPLICATION_ID
, LIN.PROGRAM_ID
, LIN.PROGRAM_UPDATE_DATE
, LIN.SOURCE_LINE_ID
, LIN.ORIGINAL_SYSTEM_LINE_REFERENCE
, LIN.HEADER_ID
, LIN.SHIPMENT_SCHEDULE_LINE_ID
, LIN.PARENT_LINE_ID
, LIN.ATO_LINE_ID
, LIN.LINK_TO_LINE_ID
, LIN.SERVICE_PARENT_LINE_ID
, LIN.LINE_TYPE_CODE
, DECODE(LIN.LINE_TYPE_CODE
, 'PARENT'
, 'Y'
, 'N' ) SHIPMENT_SCHEDULE_FLAG
, LIN.OPTION_FLAG
, LIN.OPEN_FLAG
, LIN.CYCLE_ID
, LIN.LINE_NUMBER
, LIN.INVENTORY_ITEM_ID
, MTL.DESCRIPTION ITEM_DESCRIPTION
, LIN.COMPONENT_SEQUENCE_ID
, LIN.ITEM_TYPE_CODE
, LIN.ATO_FLAG
, LIN.SHIP_MODEL_COMPLETE_FLAG
, LIN.COMPONENT_CODE
, LIN.COMPONENT_SORT_CODE
, LIN.STANDARD_COMPONENT_FREEZE_DATE
, LIN.CONFIGURATION_EDITED_FLAG
, LIN.ORDERED_QUANTITY
, LIN.CANCELLED_QUANTITY
, LIN.UNIT_CODE
, LIN.PRICE_LIST_ID
, LIN.PRICING_METHOD_CODE
, LIN.LIST_PRICE
, LIN.SELLING_PRICE
, LIN.LIST_PERCENT
, LIN.SELLING_PERCENT
, LIN.PERCENT_BASE_PRICE
, LIN.WAREHOUSE_ID
, MTLP.ORGANIZATION_CODE WAREHOUSE
, LIN.DEMAND_CLASS_CODE
, LIN.SCHEDULE_DATE
, LIN.SHIP_SET_NUMBER
, LIN.SHIPPED_QUANTITY
, LIN.DATE_REQUESTED_CURRENT
, LIN.PROMISE_DATE
, LIN.SHIP_TO_SITE_USE_ID
, RSU.LOCATION SHIP_TO_LOCATION
, RAD.CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, LIN.SHIP_TO_CONTACT_ID
, CON.LAST_NAME || DECODE(CON.FIRST_NAME
, NULL
, NULL
, '
, ' || CON.FIRST_NAME) SHIP_TO_CONTACT_NAME
, LIN.SHIPMENT_PRIORITY_CODE
, SO1.MEANING SHIPMENT_PRIORITY
, LIN.SHIP_METHOD_CODE
, LIN.AGREEMENT_ID
, LIN.COMMITMENT_ID
, LIN.TERMS_ID
, LIN.INVOICING_RULE_ID
, LIN.ACCOUNTING_RULE_ID
, LIN.INVOICE_COUNT
, LIN.INVOICED_QUANTITY
, LIN.QUANTITY_TO_INVOICE
, LIN.REVENUE_AMOUNT
, LIN.TAX_EXEMPT_NUMBER
, LIN.TAX_EXEMPT_REASON_CODE
, LIN.TRANSACTION_TYPE_CODE
, LIN.TRANSACTION_REASON_CODE
, LIN.TRANSACTION_COMMENTS
, LIN.RETURN_REFERENCE_TYPE_CODE
, LIN.RETURN_REFERENCE_ID
, LIN.CREDIT_INVOICE_LINE_ID
, LIN.INSPECTION_REQUIRED_FLAG
, LIN.CUSTOMER_PRODUCT_ID
, LIN.CP_SERVICE_ID
, LIN.SERVICED_QUANTITY
, LIN.SERVICE_DURATION
, LIN.SERVICE_START_DATE
, LIN.SERVICE_END_DATE
, LIN.SERVICE_COTERMINATE_FLAG
, LIN.SERVICE_PERIOD_CONVERSION_RATE
, LIN.SERVICE_MASS_TXN_TEMP_ID
, LIN.NUMBER_SVRID
, LIN.ITEM_SVRID
, LIN.ORDERED_QUANTITY_SVRID
, LIN.UNIT_SVRID
, LIN.PRICING_ATTRIBUTES_SVRID
, LIN.LIST_PRICE_SVRID
, LIN.SELLING_PRICE_SVRID
, LIN.LIST_PERCENT_SVRID
, LIN.SELLING_PERCENT_SVRID
, LIN.WAREHOUSE_SVRID
, LIN.DEMAND_CLASS_SVRID
, LIN.SHIP_SET_NUMBER_SVRID
, LIN.REQUEST_DATE_SVRID
, LIN.PROMISE_DATE_SVRID
, LIN.SCHEDULE_DATE_SVRID
, LIN.SHIP_TO_SVRID
, LIN.SHIP_TO_CONTACT_SVRID
, LIN.SHIPMENT_PRIORITY_SVRID
, LIN.FREIGHT_CARRIER_SVRID
, LIN.AGREEMENT_SVRID
, LIN.COMMITMENT_SVRID
, LIN.PAYMENT_TERMS_SVRID
, LIN.INVOICING_RULE_SVRID
, LIN.ACCOUNTING_RULE_SVRID
, LIN.TAX_EXEMPT_NUMBER_SVRID
, LIN.TAX_EXEMPT_REASON_SVRID
, LIN.TRANSACTION_TYPE_SVRID
, LIN.TRANSACTION_REASON_SVRID
, LIN.TRANSACTION_COMMENTS_SVRID
, LIN.RETURN_REFERENCE_TYPE_SVRID
, LIN.RETURN_REFERENCE_SVRID
, LIN.CREDIT_INVOICE_LINE_SVRID
, LIN.INSPECTION_REQUIRED_SVRID
, LIN.CUSTOMER_PRODUCT_SVRID
, LIN.CUSTOMER_PRODUCT_SERVICE_SVRID
, LIN.SERVICE_DURATION_SVRID
, LIN.SERVICE_START_DATE_SVRID
, LIN.SERVICE_END_DATE_SVRID
, LIN.SERVICE_PER_CONV_RATE_SVRID
, LIN.SERVICE_COTERMINATE_SVRID
, LIN.DF_SVRID
, LIN.S1
, LIN.S1_DATE
, LIN.S2
, LIN.S2_DATE
, LIN.S3
, LIN.S3_DATE
, LIN.S4
, LIN.S4_DATE
, LIN.S5
, LIN.S5_DATE
, LIN.S6
, LIN.S6_DATE
, LIN.S7
, LIN.S7_DATE
, LIN.S8
, LIN.S8_DATE
, LIN.S9
, LIN.S9_DATE
, LIN.S10
, LIN.S10_DATE
, LIN.S11
, LIN.S11_DATE
, LIN.S12
, LIN.S12_DATE
, LIN.S13
, LIN.S13_DATE
, LIN.S14
, LIN.S14_DATE
, LIN.S15
, LIN.S15_DATE
, LIN.S16
, LIN.S16_DATE
, LIN.S17
, LIN.S17_DATE
, LIN.S18
, LIN.S18_DATE
, LIN.S19
, LIN.S19_DATE
, LIN.S20
, LIN.S20_DATE
, LIN.S21
, LIN.S21_DATE
, LIN.S22
, LIN.S22_DATE
, LIN.S23
, LIN.S23_DATE
, LIN.S24
, LIN.S24_DATE
, LIN.S25
, LIN.S25_DATE
, LIN.S26
, LIN.S26_DATE
, LIN.S27
, LIN.S27_DATE
, LIN.S28
, LIN.S28_DATE
, LIN.S29
, LIN.S29_DATE
, LIN.S30
, LIN.S30_DATE
, LIN.CONTEXT
, LIN.ATTRIBUTE1
, LIN.ATTRIBUTE2
, LIN.ATTRIBUTE3
, LIN.ATTRIBUTE4
, LIN.ATTRIBUTE5
, LIN.ATTRIBUTE6
, LIN.ATTRIBUTE7
, LIN.ATTRIBUTE8
, LIN.ATTRIBUTE9
, LIN.ATTRIBUTE10
, LIN.ATTRIBUTE11
, LIN.ATTRIBUTE12
, LIN.ATTRIBUTE13
, LIN.ATTRIBUTE14
, LIN.ATTRIBUTE15
, LIN.PRICING_DATE
, LIN.LATEST_ACCEPTABLE_DATE
, LIN.LATEST_ACCEPTABLE_DATE_SVRID
, SOH.CURRENCY_CODE
, SOH.CUSTOMER_ID
, SOH.ORDER_NUMBER
, SOH.ORDER_TYPE_ID
, SOH.ORDER_CATEGORY
, SOH.INVOICE_TO_SITE_USE_ID
, SOT.NAME ORDER_TYPE
, SOT.STANDARD_VALUE_RULE_SET_ID
, RAC.CUSTOMER_NAME
, RAC.CUSTOMER_NUMBER
, NVL(DECODE(LIN.PARENT_LINE_ID
, NULL
, MTL.ATP_FLAG
, DECODE(MTL.ATP_FLAG
, 'N'
, MTL.ATP_FLAG
, DECODE(BIC.CHECK_ATP
, '1'
, 'Y'
, 'N' )))
, 'N' ) ATP
, MTL.SO_TRANSACTIONS_FLAG
, MTL.RESERVABLE_TYPE
, NVL(LIN.ORDERED_QUANTITY
, 0) - NVL(LIN.CANCELLED_QUANTITY
, 0) OPEN_QUANTITY
, LIN.TAX_CODE
, LIN.TAX_CODE_SVRID
, DECODE(LIN.OPTION_FLAG
, 'Y'
, LIN.LINE_NUMBER
, NULL) OPTION_NUMBER
, OEXVWLIN.SHIPMENT_NUMBER( LIN.LINE_ID
, LIN.PARENT_LINE_ID
, LIN.SHIPMENT_SCHEDULE_LINE_ID
, LIN.LINE_NUMBER) SHIPMENT_NUMBER
, OEXVWLIN.LINE_NUMBER( LIN.LINE_ID
, LIN.SHIPMENT_SCHEDULE_LINE_ID
, LIN.PARENT_LINE_ID
, LIN.LINE_NUMBER) L_NUMBER
, OE_QUERY.LINE_TOTAL( LIN.ROWID
, LIN.LINE_ID
, LIN.LINE_TYPE_CODE
, LIN.ITEM_TYPE_CODE
, LIN.SERVICE_DURATION
, NVL(MTL.SERVICEABLE_PRODUCT_FLAG
, 'N' )
, LIN.ORDERED_QUANTITY
, LIN.CANCELLED_QUANTITY
, LIN.SELLING_PRICE) LINE_TOTAL
, OE_QUERY.RESERVED_QUANTITY(LIN.LINE_ID) RESERVED_QUANTITY
, OE_QUERY.LINE_CONFIG_ITEM_EXISTS(LIN.LINE_ID) CONFIGURATION_ITEM_EXISTS
, OE_QUERY.SUPPLY_RES_DETAILS(LIN.LINE_ID) SUPPLY_RES_DETAILS
, OE_QUERY.SCHEDULE_STATUS_CODE(LIN.LINE_ID) SCHEDULE_STATUS_CODE
, SO2.MEANING SCHEDULE_STATUS
, OE_QUERY.RELEASED_QUANTITY(LIN.LINE_ID) RELEASED_QUANTITY
, LIN.CUSTOMER_ITEM_ID
, LIN.INTERMEDIATE_SHIP_TO_ID
, LIN.CUSTOMER_JOB
, LIN.CUSTOMER_PRODUCTION_LINE
, LIN.CUSTOMER_MODEL_SERIAL_NUMBER
, LIN.PLANNING_PROD_SEQ_NUMBER
, LIN.CUSTOMER_DOCK_CODE
, RSU2.LOCATION INTERMEDIATE_SHIP_TO_LOCATION
, LIN.SOURCE_TYPE_CODE
, SO3.MEANING SOURCE_TYPE
, LIN.SOURCE_TYPE_CODE_SVRID
, LIN.PLANNING_PRIORITY
, LIN.PLANNING_PRIORITY_SVRID
, LIN.END_ITEM_UNIT_NUMBER
FROM SO_LOOKUPS SO1
, RA_CONTACTS CON
, RA_SITE_USES RSU
, RA_ADDRESSES RAD
, MTL_PARAMETERS MTLP
, MTL_SYSTEM_ITEMS_VL MTL
, RA_CUSTOMERS RAC
, SO_HEADERS SOH
, SO_ORDER_TYPES SOT
, SO_LINES LIN
, SO_LOOKUPS SO2
, BOM_INVENTORY_COMPONENTS BIC
, RA_SITE_USES RSU2
, SO_LOOKUPS SO3
WHERE LIN.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID (+)
AND LIN.WAREHOUSE_ID = MTLP.ORGANIZATION_ID (+)
AND NVL(LIN.WAREHOUSE_ID
, TO_NUMBER(FND_PROFILE.VALUE( 'SO_ORGANIZATION_ID'))) = MTL.ORGANIZATION_ID (+)
AND LIN.SHIP_TO_SITE_USE_ID = RSU.SITE_USE_ID (+)
AND RAD.ADDRESS_ID (+) = RSU.ADDRESS_ID
AND LIN.SHIP_TO_CONTACT_ID = CON.CONTACT_ID (+)
AND LIN.SHIPMENT_PRIORITY_CODE = SO1.LOOKUP_CODE(+)
AND SO1.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
AND SOH.HEADER_ID = LIN.HEADER_ID
AND SOH.ORDER_TYPE_ID = SOT.ORDER_TYPE_ID (+)
AND RAC.CUSTOMER_ID (+) = SOH.CUSTOMER_ID
AND SO2.LOOKUP_TYPE (+) = 'SCHEDULE STATUS'
AND SO2.LOOKUP_CODE (+) = OE_QUERY.SCHEDULE_STATUS_CODE(LIN.LINE_ID)
AND LIN.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID (+)
AND LIN.INTERMEDIATE_SHIP_TO_ID = RSU2.SITE_USE_ID (+)
AND SO3.LOOKUP_TYPE(+) = 'SOURCE TYPE'
AND LIN.SOURCE_TYPE_CODE = SO3.LOOKUP_CODE(+)

Columns