VIEW: APPS.ASO_PVT_CUST_ORDER_HDRS_BALI_V

Source

View Text - Preformatted

SELECT OH.ORDER_NUMBER, aso_order_int.get_order_total(OH.HEADER_ID, NULL), OH.ORDERED_DATE, oh.sold_to_contact_id , OH.SOLD_TO_ORG_ID, oh.header_id , NULL , NULL , NULL , NULL , NULL , OH.TRANSACTIONAL_CURR_CODE, NULL , oh.salesrep_id , NULL , NULL , NULL , oh.flow_status_code, ou.name from oe_order_headers_all OH, (select organization_id,name from hr_operating_units where mo_global.check_access(organization_id)='Y') OU WHERE OU.organization_id= OH.org_id

View Text - HTML Formatted

SELECT OH.ORDER_NUMBER
, ASO_ORDER_INT.GET_ORDER_TOTAL(OH.HEADER_ID
, NULL)
, OH.ORDERED_DATE
, OH.SOLD_TO_CONTACT_ID
, OH.SOLD_TO_ORG_ID
, OH.HEADER_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, OH.TRANSACTIONAL_CURR_CODE
, NULL
, OH.SALESREP_ID
, NULL
, NULL
, NULL
, OH.FLOW_STATUS_CODE
, OU.NAME
FROM OE_ORDER_HEADERS_ALL OH
, (SELECT ORGANIZATION_ID
, NAME
FROM HR_OPERATING_UNITS
WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID)='Y') OU
WHERE OU.ORGANIZATION_ID= OH.ORG_ID