VIEW: APPS.OEFV_ORDER_LINES

Source

View Text - Preformatted

SELECT LINE.LINE_NUMBER, LINE.SHIPMENT_NUMBER, LINE.OPTION_NUMBER, LINE.SERVICE_NUMBER, LINE.ORDERED_QUANTITY, LINE.ORDERED_QUANTITY2, UOM.UNIT_OF_MEASURE, UOM2.UNIT_OF_MEASURE, LINE.INVOICED_QUANTITY, LINE.UNIT_SELLING_PRICE, LINE.REQUEST_DATE, LINE.SCHEDULE_SHIP_DATE, LINE.SCHEDULE_STATUS_CODE, LINE.CANCELLED_QUANTITY, LINE.CANCELLED_QUANTITY2, LINE.TAX_CODE, '_LA:LINE.FLOW_STATUS_CODE:OE_LOOKUPS:LINE_FLOW_STATUS:MEANING', LINE.FULFILLMENT_DATE, LINE.UNIT_LIST_PRICE, '_LA:LINE.CALCULATE_PRICE_FLAG:OE_LOOKUPS:CALCULATE_PRICE_FLAG:MEANING', LINE.PRICING_QUANTITY, UOM1.UNIT_OF_MEASURE, LINE.PRICING_DATE, LINE.PROMISE_DATE, LINE.SHIPPING_QUANTITY2, UOM3.UNIT_OF_MEASURE, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, PARTY.PARTY_NAME CUSTOMER, PL.NAME, AGREE.NAME, OE_BIS_SALESPERSON.GET_SALESPERSON_NAME(LINE.SALESREP_ID) SALESPERSON, ITEMS.CONCATENATED_SEGMENTS, LINE.TAX_VALUE TAX_VALUE, '_LA:LINE.SOURCE_TYPE_CODE:OE_LOOKUPS:SOURCE_TYPE:MEANING', '_LA:LINE.SHIPMENT_PRIORITY_CODE:OE_LOOKUPS:SHIPMENT_PRIORITY:MEANING', '_LA:LINE.FREIGHT_TERMS_CODE:OE_LOOKUPS:FREIGHT_TERMS:MEANING', '_LA:LINE.BOOKED_FLAG:OE_LOOKUPS:YES_NO:MEANING', '_LA:LINE.CANCELLED_FLAG:OE_LOOKUPS:YES_NO:MEANING', '_LA:LINE.OPEN_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.ACTUAL_SHIPMENT_DATE, '_LA:LINE.SHIPPABLE_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.SHIPPED_QUANTITY, LINE.SHIPPED_QUANTITY2, '_LA:LINE.FULFILLED_FLAG:OE_LOOKUPS:YES_NO:MEANING', LT.NAME, LINE.ITEM_TYPE_CODE, LINE.FULFILLED_QUANTITY, LINE.FULFILLED_QUANTITY2, LINE.LINE_CATEGORY_CODE, LINE.ORG_ID, LINE.SOLD_TO_ORG_ID, LINE.LINE_ID, LINE.HEADER_ID, LINE.SHIP_FROM_ORG_ID, LINE.INVENTORY_ITEM_ID, LINE.COMMITMENT_ID, LINE.LINE_TYPE_ID, '_DF:ONT:OE_LINE_ATTRIBUTES:LINE', LINE.SALESREP_ID, LINE.PRICE_LIST_ID, LINE.AGREEMENT_ID, '_DF:ONT:OE_LINE_PRICING_ATTRIBUTE:LINE', '_DF:ONT:OE_LINE_INDUSTRY_ATTRIBUTE:LINE', '_DF:ONT:OE_LINE_RETURN_ATTRIBUTE:LINE', '_DF:ONT:OE_LINE_TP_ATTRIBUTES:LINE', LINE.PREFERRED_GRADE, LINE.CUST_PO_NUMBER, LINE.SERVICE_DURATION, LINE.SERVICE_PERIOD, LINE.SERVICE_START_DATE, LINE.SERVICE_END_DATE, LINE.LAST_UPDATE_DATE, LINE.LAST_UPDATED_BY, LINE.CREATION_DATE, LINE.CREATED_BY, LINE.SHIPPING_QUANTITY, LINE.SHIPPING_QUANTITY_UOM, LINE.DELIVERY_LEAD_TIME, LINE.TAX_EXEMPT_FLAG, LINE.TAX_EXEMPT_NUMBER, LINE.TAX_EXEMPT_REASON_CODE, LINE.SUBINVENTORY, LINE.SHIP_TO_ORG_ID, LINE.INVOICE_TO_ORG_ID, LINE.DELIVER_TO_ORG_ID, LINE.SHIP_TO_CONTACT_ID, LINE.DELIVER_TO_CONTACT_ID, LINE.INVOICE_TO_CONTACT_ID, LINE.SHIP_TOLERANCE_ABOVE, LINE.SHIP_TOLERANCE_BELOW, LINE.DEMAND_BUCKET_TYPE_CODE, LINE.RLA_SCHEDULE_TYPE_CODE, LINE.CUSTOMER_DOCK_CODE, LINE.CUSTOMER_JOB, LINE.CUSTOMER_PRODUCTION_LINE, LINE.CUST_MODEL_SERIAL_NUMBER, LINE.PROJECT_ID, LINE.TASK_ID, LINE.TAX_DATE, LINE.TAX_RATE, LINE.DEMAND_CLASS_CODE, LINE.PRICE_REQUEST_CODE, '_LA:LINE.SHIPPING_METHOD_CODE:OE_SHIP_METHODS_V:SHIP_METHOD:MEANING' , LINE.FREIGHT_CARRIER_CODE, LINE.FOB_POINT_CODE, '_LA:LINE.TAX_POINT_CODE:OE_LOOKUPS:TAX_POINT:MEANING', LINE.PAYMENT_TERM_ID, LINE.INVOICING_RULE_ID, LINE.ACCOUNTING_RULE_ID, LINE.ACCOUNTING_RULE_DURATION, LINE.ORDER_SOURCE_ID, LINE.ORIG_SYS_DOCUMENT_REF, LINE.CHANGE_SEQUENCE, LINE.ORIG_SYS_LINE_REF, LINE.ORIG_SYS_SHIPMENT_REF, LINE.SOURCE_DOCUMENT_TYPE_ID, LINE.SOURCE_DOCUMENT_ID, LINE.SOURCE_DOCUMENT_LINE_ID, LINE.REFERENCE_TYPE, LINE.REFERENCE_LINE_ID, LINE.ITEM_REVISION, LINE.CONFIGURATION_ID, LINE.LINK_TO_LINE_ID, LINE.COMPONENT_SEQUENCE_ID, LINE.COMPONENT_CODE, LINE.CONFIG_DISPLAY_SEQUENCE, LINE.SORT_ORDER, '_LA:LINE.OPTION_FLAG:OE_LOOKUPS:YES_NO:MEANING', '_LA:LINE.DEP_PLAN_REQUIRED_FLAG:OE_LOOKUPS:YES_NO:MEANING', '_LA:LINE.VISIBLE_DEMAND_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.INTMED_SHIP_TO_ORG_ID, LINE.INTMED_SHIP_TO_CONTACT_ID, LINE.ACTUAL_ARRIVAL_DATE, LINE.ATO_LINE_ID, LINE.AUTO_SELECTED_QUANTITY, LINE.COMPONENT_NUMBER, LINE.EARLIEST_ACCEPTABLE_DATE, LINE.EXPLOSION_DATE, LINE.LATEST_ACCEPTABLE_DATE, LINE.MODEL_GROUP_NUMBER, LINE.SCHEDULE_ARRIVAL_DATE, '_LA:LINE.SHIP_MODEL_COMPLETE_FLAG:OE_LOOKUPS:YES_NO:MEANING', '_LA:LINE.RE_SOURCE_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.TOP_MODEL_LINE_ID, LINE.RETURN_REASON_CODE, LINE.ARRIVAL_SET_ID, LINE.SHIP_SET_ID, LINE.INVOICE_INTERFACE_STATUS_CODE, LINE.SPLIT_FROM_LINE_ID, LINE.LINE_SET_ID, LINE.SPLIT_BY, LINE.CUST_PRODUCTION_SEQ_NUM, '_LA:LINE.AUTHORIZED_TO_SHIP_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.VEH_CUS_ITEM_CUM_KEY_ID, '_LA:LINE.OVER_SHIP_REASON_CODE:OE_LOOKUPS:OVERSHIP_REASON:MEANING', '_LA:LINE.OVER_SHIP_RESOLVED_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.ITEM_IDENTIFIER_TYPE, '_LA:LINE.SHIPPING_INTERFACED_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.CREDIT_INVOICE_LINE_ID, LINE.FIRST_ACK_CODE, LINE.FIRST_ACK_DATE, LINE.LAST_ACK_CODE, LINE.LAST_ACK_DATE, LINE.PLANNING_PRIORITY, LINE.CONFIG_HEADER_ID, LINE.CONFIG_REV_NBR, LINE.SOLD_FROM_ORG_ID, LINE.END_ITEM_UNIT_NUMBER, LINE.SHIPPING_INSTRUCTIONS, LINE.PACKING_INSTRUCTIONS, LINE.REFERENCE_CUSTOMER_TRX_LINE_ID, LINE.SERVICE_TXN_REASON_CODE, LINE.SERVICE_TXN_COMMENTS, '_LA:LINE.SERVICE_COTERMINATE_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.UNIT_LIST_PERCENT, LINE.UNIT_SELLING_PERCENT, LINE.UNIT_PERCENT_BASE_PRICE, '_LA:LINE.SERVICE_REFERENCE_TYPE_CODE:OE_LOOKUPS:SERVICE_REFERENCE_TYPE_CODE:MEANING', LINE.SERVICE_REFERENCE_LINE_ID, LINE.SERVICE_REFERENCE_SYSTEM_ID, '_LA:LINE.MODEL_REMNANT_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.FULFILLMENT_METHOD_CODE, LINE.REVENUE_AMOUNT, LINE.CUSTOMER_LINE_NUMBER, LINE.CUSTOMER_SHIPMENT_NUMBER, LINE.CUSTOMER_PAYMENT_TERM_ID, LINE.CUSTOMER_ITEM_NET_PRICE, LINE.MARKETING_SOURCE_CODE_ID, LINE.UPGRADED_FLAG, LINE.MFG_LEAD_TIME, LINE.UNIT_SELLING_PRICE_PER_PQTY, LINE.ORIGINAL_INVENTORY_ITEM_ID, LINE.ORIGINAL_ORDERED_ITEM_ID, LINE.ORIGINAL_ORDERED_ITEM, LINE.ORIGINAL_ITEM_IDENTIFIER_TYPE, LINE.ITEM_SUBSTITUTION_TYPE_CODE, LINE.OVERRIDE_ATP_DATE_CODE, LINE.LATE_DEMAND_PENALTY_FACTOR, LINE.TRANSACTION_PHASE_CODE, LINE.ORIGINAL_LIST_PRICE, LINE.ORDER_FIRMED_DATE, LINE.ACTUAL_FULFILLMENT_DATE, LINE.charge_periodicity_code , LINE.CONTINGENCY_ID , LINE.REVREC_EVENT_CODE , LINE.REVREC_EXPIRATION_DAYS , LINE.ACCEPTED_QUANTITY , LINE.ACCEPTED_BY , LINE.REVREC_COMMENTS , LINE.REVREC_REFERENCE_DOCUMENT , LINE.REVREC_SIGNATURE , LINE.REVREC_SIGNATURE_DATE , LINE.REVREC_IMPLICIT_FLAG FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, OE_ORDER_LINES_ALL LINE, OE_AGREEMENTS AGREE, OE_TRANSACTION_TYPES_TL lt, QP_LIST_HEADERS_TL PL, MTL_SYSTEM_ITEMS_VL ITEMS, MTL_UNITS_OF_MEASURE_TL UOM, MTL_UNITS_OF_MEASURE_TL UOM1, MTL_UNITS_OF_MEASURE_TL UOM2, MTL_UNITS_OF_MEASURE_TL UOM3 WHERE LINE.line_type_id = lt.transaction_type_id AND lt.language = userenv('LANG') AND LINE.agreement_id = agree.agreement_id(+) AND LINE.price_list_id = pl.list_header_id(+) AND pl.language(+) = userenv('LANG') AND LINE.sold_to_org_id = cust_acct.cust_account_id(+) AND PARTY.party_id(+) = cust_acct.party_id AND LINE.inventory_item_id = items.inventory_item_id(+) AND items.organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID', LINE.ORG_ID) AND LINE.order_quantity_uom = uom.uom_code(+) AND UOM.language(+) = userenv('LANG') AND LINE.ordered_quantity_uom2= uom2.uom_code(+) AND UOM2.language(+) = userenv('LANG') AND LINE.pricing_quantity_uom = uom1.uom_code(+) AND UOM1.language(+) = userenv('LANG') AND LINE.shipping_quantity_uom2= uom3.uom_code(+) AND UOM3.language(+) = userenv('LANG') AND '_SEC:LINE.ORG_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT LINE.LINE_NUMBER
, LINE.SHIPMENT_NUMBER
, LINE.OPTION_NUMBER
, LINE.SERVICE_NUMBER
, LINE.ORDERED_QUANTITY
, LINE.ORDERED_QUANTITY2
, UOM.UNIT_OF_MEASURE
, UOM2.UNIT_OF_MEASURE
, LINE.INVOICED_QUANTITY
, LINE.UNIT_SELLING_PRICE
, LINE.REQUEST_DATE
, LINE.SCHEDULE_SHIP_DATE
, LINE.SCHEDULE_STATUS_CODE
, LINE.CANCELLED_QUANTITY
, LINE.CANCELLED_QUANTITY2
, LINE.TAX_CODE
, '_LA:LINE.FLOW_STATUS_CODE:OE_LOOKUPS:LINE_FLOW_STATUS:MEANING'
, LINE.FULFILLMENT_DATE
, LINE.UNIT_LIST_PRICE
, '_LA:LINE.CALCULATE_PRICE_FLAG:OE_LOOKUPS:CALCULATE_PRICE_FLAG:MEANING'
, LINE.PRICING_QUANTITY
, UOM1.UNIT_OF_MEASURE
, LINE.PRICING_DATE
, LINE.PROMISE_DATE
, LINE.SHIPPING_QUANTITY2
, UOM3.UNIT_OF_MEASURE
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, PARTY.PARTY_NAME CUSTOMER
, PL.NAME
, AGREE.NAME
, OE_BIS_SALESPERSON.GET_SALESPERSON_NAME(LINE.SALESREP_ID) SALESPERSON
, ITEMS.CONCATENATED_SEGMENTS
, LINE.TAX_VALUE TAX_VALUE
, '_LA:LINE.SOURCE_TYPE_CODE:OE_LOOKUPS:SOURCE_TYPE:MEANING'
, '_LA:LINE.SHIPMENT_PRIORITY_CODE:OE_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, '_LA:LINE.FREIGHT_TERMS_CODE:OE_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:LINE.BOOKED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.CANCELLED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.OPEN_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.ACTUAL_SHIPMENT_DATE
, '_LA:LINE.SHIPPABLE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.SHIPPED_QUANTITY
, LINE.SHIPPED_QUANTITY2
, '_LA:LINE.FULFILLED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LT.NAME
, LINE.ITEM_TYPE_CODE
, LINE.FULFILLED_QUANTITY
, LINE.FULFILLED_QUANTITY2
, LINE.LINE_CATEGORY_CODE
, LINE.ORG_ID
, LINE.SOLD_TO_ORG_ID
, LINE.LINE_ID
, LINE.HEADER_ID
, LINE.SHIP_FROM_ORG_ID
, LINE.INVENTORY_ITEM_ID
, LINE.COMMITMENT_ID
, LINE.LINE_TYPE_ID
, '_DF:ONT:OE_LINE_ATTRIBUTES:LINE'
, LINE.SALESREP_ID
, LINE.PRICE_LIST_ID
, LINE.AGREEMENT_ID
, '_DF:ONT:OE_LINE_PRICING_ATTRIBUTE:LINE'
, '_DF:ONT:OE_LINE_INDUSTRY_ATTRIBUTE:LINE'
, '_DF:ONT:OE_LINE_RETURN_ATTRIBUTE:LINE'
, '_DF:ONT:OE_LINE_TP_ATTRIBUTES:LINE'
, LINE.PREFERRED_GRADE
, LINE.CUST_PO_NUMBER
, LINE.SERVICE_DURATION
, LINE.SERVICE_PERIOD
, LINE.SERVICE_START_DATE
, LINE.SERVICE_END_DATE
, LINE.LAST_UPDATE_DATE
, LINE.LAST_UPDATED_BY
, LINE.CREATION_DATE
, LINE.CREATED_BY
, LINE.SHIPPING_QUANTITY
, LINE.SHIPPING_QUANTITY_UOM
, LINE.DELIVERY_LEAD_TIME
, LINE.TAX_EXEMPT_FLAG
, LINE.TAX_EXEMPT_NUMBER
, LINE.TAX_EXEMPT_REASON_CODE
, LINE.SUBINVENTORY
, LINE.SHIP_TO_ORG_ID
, LINE.INVOICE_TO_ORG_ID
, LINE.DELIVER_TO_ORG_ID
, LINE.SHIP_TO_CONTACT_ID
, LINE.DELIVER_TO_CONTACT_ID
, LINE.INVOICE_TO_CONTACT_ID
, LINE.SHIP_TOLERANCE_ABOVE
, LINE.SHIP_TOLERANCE_BELOW
, LINE.DEMAND_BUCKET_TYPE_CODE
, LINE.RLA_SCHEDULE_TYPE_CODE
, LINE.CUSTOMER_DOCK_CODE
, LINE.CUSTOMER_JOB
, LINE.CUSTOMER_PRODUCTION_LINE
, LINE.CUST_MODEL_SERIAL_NUMBER
, LINE.PROJECT_ID
, LINE.TASK_ID
, LINE.TAX_DATE
, LINE.TAX_RATE
, LINE.DEMAND_CLASS_CODE
, LINE.PRICE_REQUEST_CODE
, '_LA:LINE.SHIPPING_METHOD_CODE:OE_SHIP_METHODS_V:SHIP_METHOD:MEANING'
, LINE.FREIGHT_CARRIER_CODE
, LINE.FOB_POINT_CODE
, '_LA:LINE.TAX_POINT_CODE:OE_LOOKUPS:TAX_POINT:MEANING'
, LINE.PAYMENT_TERM_ID
, LINE.INVOICING_RULE_ID
, LINE.ACCOUNTING_RULE_ID
, LINE.ACCOUNTING_RULE_DURATION
, LINE.ORDER_SOURCE_ID
, LINE.ORIG_SYS_DOCUMENT_REF
, LINE.CHANGE_SEQUENCE
, LINE.ORIG_SYS_LINE_REF
, LINE.ORIG_SYS_SHIPMENT_REF
, LINE.SOURCE_DOCUMENT_TYPE_ID
, LINE.SOURCE_DOCUMENT_ID
, LINE.SOURCE_DOCUMENT_LINE_ID
, LINE.REFERENCE_TYPE
, LINE.REFERENCE_LINE_ID
, LINE.ITEM_REVISION
, LINE.CONFIGURATION_ID
, LINE.LINK_TO_LINE_ID
, LINE.COMPONENT_SEQUENCE_ID
, LINE.COMPONENT_CODE
, LINE.CONFIG_DISPLAY_SEQUENCE
, LINE.SORT_ORDER
, '_LA:LINE.OPTION_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.DEP_PLAN_REQUIRED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.VISIBLE_DEMAND_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.INTMED_SHIP_TO_ORG_ID
, LINE.INTMED_SHIP_TO_CONTACT_ID
, LINE.ACTUAL_ARRIVAL_DATE
, LINE.ATO_LINE_ID
, LINE.AUTO_SELECTED_QUANTITY
, LINE.COMPONENT_NUMBER
, LINE.EARLIEST_ACCEPTABLE_DATE
, LINE.EXPLOSION_DATE
, LINE.LATEST_ACCEPTABLE_DATE
, LINE.MODEL_GROUP_NUMBER
, LINE.SCHEDULE_ARRIVAL_DATE
, '_LA:LINE.SHIP_MODEL_COMPLETE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.RE_SOURCE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.TOP_MODEL_LINE_ID
, LINE.RETURN_REASON_CODE
, LINE.ARRIVAL_SET_ID
, LINE.SHIP_SET_ID
, LINE.INVOICE_INTERFACE_STATUS_CODE
, LINE.SPLIT_FROM_LINE_ID
, LINE.LINE_SET_ID
, LINE.SPLIT_BY
, LINE.CUST_PRODUCTION_SEQ_NUM
, '_LA:LINE.AUTHORIZED_TO_SHIP_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.VEH_CUS_ITEM_CUM_KEY_ID
, '_LA:LINE.OVER_SHIP_REASON_CODE:OE_LOOKUPS:OVERSHIP_REASON:MEANING'
, '_LA:LINE.OVER_SHIP_RESOLVED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.ITEM_IDENTIFIER_TYPE
, '_LA:LINE.SHIPPING_INTERFACED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.CREDIT_INVOICE_LINE_ID
, LINE.FIRST_ACK_CODE
, LINE.FIRST_ACK_DATE
, LINE.LAST_ACK_CODE
, LINE.LAST_ACK_DATE
, LINE.PLANNING_PRIORITY
, LINE.CONFIG_HEADER_ID
, LINE.CONFIG_REV_NBR
, LINE.SOLD_FROM_ORG_ID
, LINE.END_ITEM_UNIT_NUMBER
, LINE.SHIPPING_INSTRUCTIONS
, LINE.PACKING_INSTRUCTIONS
, LINE.REFERENCE_CUSTOMER_TRX_LINE_ID
, LINE.SERVICE_TXN_REASON_CODE
, LINE.SERVICE_TXN_COMMENTS
, '_LA:LINE.SERVICE_COTERMINATE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.UNIT_LIST_PERCENT
, LINE.UNIT_SELLING_PERCENT
, LINE.UNIT_PERCENT_BASE_PRICE
, '_LA:LINE.SERVICE_REFERENCE_TYPE_CODE:OE_LOOKUPS:SERVICE_REFERENCE_TYPE_CODE:MEANING'
, LINE.SERVICE_REFERENCE_LINE_ID
, LINE.SERVICE_REFERENCE_SYSTEM_ID
, '_LA:LINE.MODEL_REMNANT_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.FULFILLMENT_METHOD_CODE
, LINE.REVENUE_AMOUNT
, LINE.CUSTOMER_LINE_NUMBER
, LINE.CUSTOMER_SHIPMENT_NUMBER
, LINE.CUSTOMER_PAYMENT_TERM_ID
, LINE.CUSTOMER_ITEM_NET_PRICE
, LINE.MARKETING_SOURCE_CODE_ID
, LINE.UPGRADED_FLAG
, LINE.MFG_LEAD_TIME
, LINE.UNIT_SELLING_PRICE_PER_PQTY
, LINE.ORIGINAL_INVENTORY_ITEM_ID
, LINE.ORIGINAL_ORDERED_ITEM_ID
, LINE.ORIGINAL_ORDERED_ITEM
, LINE.ORIGINAL_ITEM_IDENTIFIER_TYPE
, LINE.ITEM_SUBSTITUTION_TYPE_CODE
, LINE.OVERRIDE_ATP_DATE_CODE
, LINE.LATE_DEMAND_PENALTY_FACTOR
, LINE.TRANSACTION_PHASE_CODE
, LINE.ORIGINAL_LIST_PRICE
, LINE.ORDER_FIRMED_DATE
, LINE.ACTUAL_FULFILLMENT_DATE
, LINE.CHARGE_PERIODICITY_CODE
, LINE.CONTINGENCY_ID
, LINE.REVREC_EVENT_CODE
, LINE.REVREC_EXPIRATION_DAYS
, LINE.ACCEPTED_QUANTITY
, LINE.ACCEPTED_BY
, LINE.REVREC_COMMENTS
, LINE.REVREC_REFERENCE_DOCUMENT
, LINE.REVREC_SIGNATURE
, LINE.REVREC_SIGNATURE_DATE
, LINE.REVREC_IMPLICIT_FLAG
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, OE_ORDER_LINES_ALL LINE
, OE_AGREEMENTS AGREE
, OE_TRANSACTION_TYPES_TL LT
, QP_LIST_HEADERS_TL PL
, MTL_SYSTEM_ITEMS_VL ITEMS
, MTL_UNITS_OF_MEASURE_TL UOM
, MTL_UNITS_OF_MEASURE_TL UOM1
, MTL_UNITS_OF_MEASURE_TL UOM2
, MTL_UNITS_OF_MEASURE_TL UOM3
WHERE LINE.LINE_TYPE_ID = LT.TRANSACTION_TYPE_ID
AND LT.LANGUAGE = USERENV('LANG')
AND LINE.AGREEMENT_ID = AGREE.AGREEMENT_ID(+)
AND LINE.PRICE_LIST_ID = PL.LIST_HEADER_ID(+)
AND PL.LANGUAGE(+) = USERENV('LANG')
AND LINE.SOLD_TO_ORG_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID
AND LINE.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID(+)
AND ITEMS.ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
, LINE.ORG_ID)
AND LINE.ORDER_QUANTITY_UOM = UOM.UOM_CODE(+)
AND UOM.LANGUAGE(+) = USERENV('LANG')
AND LINE.ORDERED_QUANTITY_UOM2= UOM2.UOM_CODE(+)
AND UOM2.LANGUAGE(+) = USERENV('LANG')
AND LINE.PRICING_QUANTITY_UOM = UOM1.UOM_CODE(+)
AND UOM1.LANGUAGE(+) = USERENV('LANG')
AND LINE.SHIPPING_QUANTITY_UOM2= UOM3.UOM_CODE(+)
AND UOM3.LANGUAGE(+) = USERENV('LANG')
AND '_SEC:LINE.ORG_ID' IS NOT NULL WITH READ ONLY