View: SO_LINES_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
, MTL.BOM_ITEM_TYPE
, NVL(MTL.SERVICEABLE_PRODUCT_FLAG
, 'N' ) SERVICEABLE_PRODUCT_FLAG
, LIN.COMPONENT_SEQUENCE_ID
, LIN.ITEM_TYPE_CODE
, SO2.MEANING ITEM_TYPE
, LIN.ATO_FLAG
, DECODE(LIN.ATO_FLAG
, 'Y'
, 'Y'
, OE_QUERY.ATO_INDICATOR(LIN.LINE_ID
, LIN.ITEM_TYPE_CODE)) ATO_INDICATOR_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.TAX_CODE
, LIN.PRICE_LIST_ID
, SPL.NAME PRICE_LIST
, -SPL.ROUNDING_FACTOR ROUNDING_FACTOR
, LIN.PRICING_METHOD_CODE
, LIN.LIST_PRICE
, LIN.SELLING_PRICE
, LIN.LIST_PERCENT
, LIN.SELLING_PERCENT
, LIN.PERCENT_BASE_PRICE
, 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) TOTAL
, LIN.PRICING_CONTEXT
, LIN.PRICING_ATTRIBUTE1
, LIN.PRICING_ATTRIBUTE2
, LIN.PRICING_ATTRIBUTE3
, LIN.PRICING_ATTRIBUTE4
, LIN.PRICING_ATTRIBUTE5
, LIN.PRICING_ATTRIBUTE6
, LIN.PRICING_ATTRIBUTE7
, LIN.PRICING_ATTRIBUTE8
, LIN.PRICING_ATTRIBUTE9
, LIN.PRICING_ATTRIBUTE10
, LIN.PRICING_ATTRIBUTE11
, LIN.PRICING_ATTRIBUTE12
, LIN.PRICING_ATTRIBUTE13
, LIN.PRICING_ATTRIBUTE14
, LIN.PRICING_ATTRIBUTE15
, LIN.WAREHOUSE_ID
, OOD.ORGANIZATION_CODE WAREHOUSE_CODE
, 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
, RAD.CITY||' ' ||RAD.COUNTRY SHIP_TO_CITY
, 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
, SAG.NAME AGREEMENT
, LIN.COMMITMENT_ID
, TRX.TRX_NUMBER COMMITMENT
, LIN.TERMS_ID
, RTM.NAME PAYMENT_TERMS
, 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
, ARL.MEANING CREDIT_MEMO_REASON
, LIN.CUSTOMER_PRODUCT_ID
, CSCP.UNIT_OF_MEASURE_CODE SERVICED_UNIT_CODE
, CSCP.REFERENCE_NUMBER CP_SERIAL_NUMBER
, CSSYS.NAME SYSTEM
, 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.TAX_CODE_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
, OE_QUERY.RESERVED_QUANTITY(LIN.LINE_ID) RESERVED_QUANTITY
, OE_QUERY.LINE_CONFIG_ITEM_EXISTS(LIN.LINE_ID) CONFIGURATION_ITEM_EXISTS_FLAG
, OE_QUERY.SUPPLY_RES_DETAILS(LIN.LINE_ID) SUPPLY_RESERVATION_EXISTS_FLAG
, OE_QUERY.SCHEDULE_STATUS_CODE(LIN.LINE_ID) SCHEDULE_STATUS_CODE
, OE_QUERY.SCHEDULE_STATUS(LIN.LINE_ID) SCHEDULE_STATUS
, OE_QUERY.SERVICE_TOTAL(LIN.ROWID
, LIN.LINE_ID
, LIN.PARENT_LINE_ID
, LIN.ITEM_TYPE_CODE
, NVL(MTL.SERVICEABLE_PRODUCT_FLAG
, 'N' )) SERVICE_TOTAL
, 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
, LIN.SOURCE_TYPE_CODE_SVRID
, LIN.PLANNING_PRIORITY
, LIN.PLANNING_PRIORITY_SVRID
, LIN.END_ITEM_UNIT_NUMBER
FROM SO_LOOKUPS SO3
, SO_LOOKUPS SO2
, SO_LOOKUPS SO1
, AR_LOOKUPS ARL
, RA_TERMS RTM
, CS_SYSTEMS_VL CSSYS
, CS_CUSTOMER_PRODUCTS CSCP
, RA_CUSTOMER_TRX TRX
, SO_AGREEMENTS SAG
, RA_CONTACTS CON
, RA_SITE_USES RSU
, RA_ADDRESSES RAD
, MTL_PARAMETERS OOD
, SO_PRICE_LISTS SPL
, MTL_SYSTEM_ITEMS_VL MTL
, SO_LINES LIN
, RA_SITE_USES RSU2
WHERE LIN.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
AND MTL.ORGANIZATION_ID = FND_PROFILE.VALUE('SO_ORGANIZATION_ID')
AND LIN.PRICE_LIST_ID = SPL.PRICE_LIST_ID (+)
AND LIN.WAREHOUSE_ID = OOD.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.AGREEMENT_ID = SAG.AGREEMENT_ID (+)
AND LIN.COMMITMENT_ID = TRX.CUSTOMER_TRX_ID (+)
AND LIN.CUSTOMER_PRODUCT_ID = CSCP.CUSTOMER_PRODUCT_ID(+)
AND CSSYS.SYSTEM_ID (+) = CSCP.SYSTEM_ID
AND LIN.TRANSACTION_REASON_CODE = ARL.LOOKUP_CODE (+)
AND ARL.LOOKUP_TYPE (+) = 'CREDIT_MEMO_REASON'
AND LIN.TERMS_ID = RTM.TERM_ID (+)
AND LIN.SHIPMENT_PRIORITY_CODE = SO1.LOOKUP_CODE(+)
AND SO1.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
AND LIN.ITEM_TYPE_CODE = SO2.LOOKUP_CODE
AND SO2.LOOKUP_TYPE = 'ITEM TYPE'
AND SO3.LOOKUP_TYPE(+) ='SOURCE TYPE'
AND LIN.SOURCE_TYPE_CODE = SO3.LOOKUP_CODE(+)
AND LIN.INTERMEDIATE_SHIP_TO_ID = RSU2.SITE_USE_ID (+)

Columns