APPS.OEFV_ORDER_LINES
[Home] [Help]
| Product: | ONT - Order Management |
|---|---|
| Description: | Full BIS View for Order lines |
| Implementation/DBA Data: |
APPS.OEFV_ORDER_LINES
|
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