VIEW: APPS.ASO_I_ORDER_HEADERS_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, (select name from hr_operating_units where organization_id = oh.org_id) from oe_order_headers_all OH

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
, (SELECT NAME
FROM HR_OPERATING_UNITS
WHERE ORGANIZATION_ID = OH.ORG_ID)
FROM OE_ORDER_HEADERS_ALL OH