VIEW: APPS.JTM_OE_ORDER_LINES_ALL_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.LINE_ID , B.ORG_ID , B.HEADER_ID , B.LINE_TYPE_ID , B.LINE_NUMBER , B.ORDERED_ITEM , B.REQUEST_DATE , B.PROMISE_DATE , B.SCHEDULE_SHIP_DATE , B.ORDER_QUANTITY_UOM , B.PRICING_QUANTITY , B.PRICING_QUANTITY_UOM , B.CANCELLED_QUANTITY , B.SHIPPED_QUANTITY , B.ORDERED_QUANTITY , B.FULFILLED_QUANTITY , B.SHIPPING_QUANTITY , B.SHIPPING_QUANTITY_UOM , B.DELIVERY_LEAD_TIME , B.SHIP_FROM_ORG_ID , B.SHIP_TO_ORG_ID , B.CUST_PO_NUMBER , B.PROJECT_ID , B.TASK_ID , B.INVENTORY_ITEM_ID , B.SHIPMENT_NUMBER , B.SHIPMENT_PRIORITY_CODE , B.SHIPPING_METHOD_CODE , B.SOURCE_DOCUMENT_TYPE_ID , B.SOURCE_DOCUMENT_ID , B.SOURCE_DOCUMENT_LINE_ID , B.REFERENCE_LINE_ID , B.REFERENCE_TYPE , B.REFERENCE_HEADER_ID , B.ITEM_REVISION , B.REQUEST_ID , B.SORT_ORDER , B.ITEM_TYPE_CODE , B.LINE_CATEGORY_CODE , B.ACTUAL_ARRIVAL_DATE , B.EARLIEST_ACCEPTABLE_DATE , B.LATEST_ACCEPTABLE_DATE , B.SCHEDULE_ARRIVAL_DATE , B.SCHEDULE_STATUS_CODE , B.SOURCE_TYPE_CODE , B.CANCELLED_FLAG , B.OPEN_FLAG , B.BOOKED_FLAG , B.RETURN_REASON_CODE , B.ORDERED_ITEM_ID , B.SHIPPING_INTERFACED_FLAG , B.PLANNING_PRIORITY , B.ORDER_SOURCE_ID , B.DROP_SHIP_FLAG , B.CONFIG_HEADER_ID , B.SHIPPING_INSTRUCTIONS , B.PACKING_INSTRUCTIONS , B.INVOICED_QUANTITY , B.SHIPPABLE_FLAG , B.FLOW_STATUS_CODE , B.ORDERED_QUANTITY2 , B.ORDERED_QUANTITY_UOM2 , B.SHIPPING_QUANTITY2 , B.CANCELLED_QUANTITY2 , B.SHIPPED_QUANTITY2 , B.SHIPPING_QUANTITY_UOM2 , B.FULFILLED_QUANTITY2 , B.LOCK_CONTROL , B.SUBINVENTORY , OL.MEANING AS ORDER_STATUS FROM OE_ORDER_LINES_ALL B , JTM_OE_ORDER_LINES_ALL_ACC A , OE_LOOKUPS OL WHERE A.LINE_ID = B.LINE_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID AND OL.LOOKUP_TYPE (+) = 'LINE_FLOW_STATUS' AND OL.LOOKUP_CODE (+) = B.FLOW_STATUS_CODE

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.LINE_ID
, B.ORG_ID
, B.HEADER_ID
, B.LINE_TYPE_ID
, B.LINE_NUMBER
, B.ORDERED_ITEM
, B.REQUEST_DATE
, B.PROMISE_DATE
, B.SCHEDULE_SHIP_DATE
, B.ORDER_QUANTITY_UOM
, B.PRICING_QUANTITY
, B.PRICING_QUANTITY_UOM
, B.CANCELLED_QUANTITY
, B.SHIPPED_QUANTITY
, B.ORDERED_QUANTITY
, B.FULFILLED_QUANTITY
, B.SHIPPING_QUANTITY
, B.SHIPPING_QUANTITY_UOM
, B.DELIVERY_LEAD_TIME
, B.SHIP_FROM_ORG_ID
, B.SHIP_TO_ORG_ID
, B.CUST_PO_NUMBER
, B.PROJECT_ID
, B.TASK_ID
, B.INVENTORY_ITEM_ID
, B.SHIPMENT_NUMBER
, B.SHIPMENT_PRIORITY_CODE
, B.SHIPPING_METHOD_CODE
, B.SOURCE_DOCUMENT_TYPE_ID
, B.SOURCE_DOCUMENT_ID
, B.SOURCE_DOCUMENT_LINE_ID
, B.REFERENCE_LINE_ID
, B.REFERENCE_TYPE
, B.REFERENCE_HEADER_ID
, B.ITEM_REVISION
, B.REQUEST_ID
, B.SORT_ORDER
, B.ITEM_TYPE_CODE
, B.LINE_CATEGORY_CODE
, B.ACTUAL_ARRIVAL_DATE
, B.EARLIEST_ACCEPTABLE_DATE
, B.LATEST_ACCEPTABLE_DATE
, B.SCHEDULE_ARRIVAL_DATE
, B.SCHEDULE_STATUS_CODE
, B.SOURCE_TYPE_CODE
, B.CANCELLED_FLAG
, B.OPEN_FLAG
, B.BOOKED_FLAG
, B.RETURN_REASON_CODE
, B.ORDERED_ITEM_ID
, B.SHIPPING_INTERFACED_FLAG
, B.PLANNING_PRIORITY
, B.ORDER_SOURCE_ID
, B.DROP_SHIP_FLAG
, B.CONFIG_HEADER_ID
, B.SHIPPING_INSTRUCTIONS
, B.PACKING_INSTRUCTIONS
, B.INVOICED_QUANTITY
, B.SHIPPABLE_FLAG
, B.FLOW_STATUS_CODE
, B.ORDERED_QUANTITY2
, B.ORDERED_QUANTITY_UOM2
, B.SHIPPING_QUANTITY2
, B.CANCELLED_QUANTITY2
, B.SHIPPED_QUANTITY2
, B.SHIPPING_QUANTITY_UOM2
, B.FULFILLED_QUANTITY2
, B.LOCK_CONTROL
, B.SUBINVENTORY
, OL.MEANING AS ORDER_STATUS
FROM OE_ORDER_LINES_ALL B
, JTM_OE_ORDER_LINES_ALL_ACC A
, OE_LOOKUPS OL
WHERE A.LINE_ID = B.LINE_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
AND OL.LOOKUP_TYPE (+) = 'LINE_FLOW_STATUS'
AND OL.LOOKUP_CODE (+) = B.FLOW_STATUS_CODE