VIEW: APPS.OEBV_ORDER_LINES

Source

View Text - Preformatted

SELECT LINE.LINE_NUMBER, LINE.ORDERED_QUANTITY, LINE.ORDER_QUANTITY_UOM, LINE.INVOICED_QUANTITY, LINE.UNIT_SELLING_PRICE, LINE.REQUEST_DATE, LINE.SCHEDULE_SHIP_DATE, LINE.SCHEDULE_STATUS_CODE, LINE.CANCELLED_QUANTITY, LINE.TAX_CODE, LINE.FULFILLMENT_DATE, LINE.UNIT_LIST_PRICE, '_LA:LINE.CALCULATE_PRICE_FLAG:OE_LOOKUPS:CALCULATE_PRICE_FLAG:MEANING', LINE.PRICING_QUANTITY, LINE.PRICING_QUANTITY_UOM, LINE.PRICING_DATE, LINE.PROMISE_DATE, LINE.SOLD_TO_ORG_ID, LINE.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, '_LA:LINE.FULFILLED_FLAG:OE_LOOKUPS:YES_NO:MEANING', LINE.ITEM_TYPE_CODE, LINE.FULFILLED_QUANTITY, 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, LINE.SALESREP_ID, LINE.PRICE_LIST_ID, LINE.AGREEMENT_ID, '_DF:ONT:OE_LINE_PRICING_ATTRIBUTE:LINE', LINE.LAST_UPDATE_DATE, LINE.LAST_UPDATED_BY, LINE.CREATION_DATE, LINE.CREATED_BY, LINE.ORIGINAL_LIST_PRICE, LINE.ORDER_SOURCE_ID, LINE.charge_periodicity_code, LINE.END_CUSTOMER_ID, LINE.END_CUSTOMER_CONTACT_ID, LINE.END_CUSTOMER_SITE_USE_ID, '_LA:LINE.IB_OWNER:OE_LOOKUPS:ITEM_OWNER:MEANING', '_LA:LINE.IB_CURRENT_LOCATION:OE_LOOKUPS:ITEM_CURRENT_LOCATION:MEANING', '_LA:LINE.IB_INSTALLED_AT_LOCATION:OE_LOOKUPS:ITEM_INSTALL_LOCATION:MEANING' , 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 OE_ORDER_LINES LINE WHERE '_SEC:LINE.SHIP_FROM_ORG_ID' IS NOT NULL

View Text - HTML Formatted

SELECT LINE.LINE_NUMBER
, LINE.ORDERED_QUANTITY
, LINE.ORDER_QUANTITY_UOM
, LINE.INVOICED_QUANTITY
, LINE.UNIT_SELLING_PRICE
, LINE.REQUEST_DATE
, LINE.SCHEDULE_SHIP_DATE
, LINE.SCHEDULE_STATUS_CODE
, LINE.CANCELLED_QUANTITY
, LINE.TAX_CODE
, LINE.FULFILLMENT_DATE
, LINE.UNIT_LIST_PRICE
, '_LA:LINE.CALCULATE_PRICE_FLAG:OE_LOOKUPS:CALCULATE_PRICE_FLAG:MEANING'
, LINE.PRICING_QUANTITY
, LINE.PRICING_QUANTITY_UOM
, LINE.PRICING_DATE
, LINE.PROMISE_DATE
, LINE.SOLD_TO_ORG_ID
, LINE.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
, '_LA:LINE.FULFILLED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.ITEM_TYPE_CODE
, LINE.FULFILLED_QUANTITY
, 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
, LINE.SALESREP_ID
, LINE.PRICE_LIST_ID
, LINE.AGREEMENT_ID
, '_DF:ONT:OE_LINE_PRICING_ATTRIBUTE:LINE'
, LINE.LAST_UPDATE_DATE
, LINE.LAST_UPDATED_BY
, LINE.CREATION_DATE
, LINE.CREATED_BY
, LINE.ORIGINAL_LIST_PRICE
, LINE.ORDER_SOURCE_ID
, LINE.CHARGE_PERIODICITY_CODE
, LINE.END_CUSTOMER_ID
, LINE.END_CUSTOMER_CONTACT_ID
, LINE.END_CUSTOMER_SITE_USE_ID
, '_LA:LINE.IB_OWNER:OE_LOOKUPS:ITEM_OWNER:MEANING'
, '_LA:LINE.IB_CURRENT_LOCATION:OE_LOOKUPS:ITEM_CURRENT_LOCATION:MEANING'
, '_LA:LINE.IB_INSTALLED_AT_LOCATION:OE_LOOKUPS:ITEM_INSTALL_LOCATION:MEANING'
, 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 OE_ORDER_LINES LINE
WHERE '_SEC:LINE.SHIP_FROM_ORG_ID' IS NOT NULL