VIEW: APPS.JTM_OE_ORDER_HEADERS_ALL_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.HEADER_ID , B.ORG_ID , B.ORDER_TYPE_ID , B.ORDER_NUMBER , B.VERSION_NUMBER , B.EXPIRATION_DATE , B.ORDER_SOURCE_ID , B.SOURCE_DOCUMENT_TYPE_ID , B.SOURCE_DOCUMENT_ID , B.ORDERED_DATE , B.REQUEST_DATE , B.PRICING_DATE , B.SHIPMENT_PRIORITY_CODE , B.PARTIAL_SHIPMENTS_ALLOWED , B.CUST_PO_NUMBER , B.SHIPPING_METHOD_CODE , B.FREIGHT_CARRIER_CODE , B.SHIP_FROM_ORG_ID , B.SHIP_TO_ORG_ID , B.REQUEST_ID , B.CANCELLED_FLAG , B.OPEN_FLAG , B.BOOKED_FLAG , B.RETURN_REASON_CODE , B.EARLIEST_SCHEDULE_LIMIT , B.LATEST_SCHEDULE_LIMIT , B.ORDER_CATEGORY_CODE , B.SHIPPING_INSTRUCTIONS , B.PACKING_INSTRUCTIONS , B.FLOW_STATUS_CODE , B.BOOKED_DATE , B.LOCK_CONTROL FROM OE_ORDER_HEADERS_ALL B , JTM_OE_ORDER_HEADERS_ALL_ACC A WHERE A.HEADER_ID = B.HEADER_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.HEADER_ID
, B.ORG_ID
, B.ORDER_TYPE_ID
, B.ORDER_NUMBER
, B.VERSION_NUMBER
, B.EXPIRATION_DATE
, B.ORDER_SOURCE_ID
, B.SOURCE_DOCUMENT_TYPE_ID
, B.SOURCE_DOCUMENT_ID
, B.ORDERED_DATE
, B.REQUEST_DATE
, B.PRICING_DATE
, B.SHIPMENT_PRIORITY_CODE
, B.PARTIAL_SHIPMENTS_ALLOWED
, B.CUST_PO_NUMBER
, B.SHIPPING_METHOD_CODE
, B.FREIGHT_CARRIER_CODE
, B.SHIP_FROM_ORG_ID
, B.SHIP_TO_ORG_ID
, B.REQUEST_ID
, B.CANCELLED_FLAG
, B.OPEN_FLAG
, B.BOOKED_FLAG
, B.RETURN_REASON_CODE
, B.EARLIEST_SCHEDULE_LIMIT
, B.LATEST_SCHEDULE_LIMIT
, B.ORDER_CATEGORY_CODE
, B.SHIPPING_INSTRUCTIONS
, B.PACKING_INSTRUCTIONS
, B.FLOW_STATUS_CODE
, B.BOOKED_DATE
, B.LOCK_CONTROL
FROM OE_ORDER_HEADERS_ALL B
, JTM_OE_ORDER_HEADERS_ALL_ACC A
WHERE A.HEADER_ID = B.HEADER_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID