VIEW: APPS.CSM_ORDER_HEADERS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.HEADER_ID , B.ORG_ID , B.ORDER_NUMBER , B.ORDER_SOURCE_ID FROM OE_ORDER_HEADERS_ALL B , CSM_ORDER_HEADERS_ACC ACC WHERE ACC.HEADER_ID = B.HEADER_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.HEADER_ID
, B.ORG_ID
, B.ORDER_NUMBER
, B.ORDER_SOURCE_ID
FROM OE_ORDER_HEADERS_ALL B
, CSM_ORDER_HEADERS_ACC ACC
WHERE ACC.HEADER_ID = B.HEADER_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID