View: ASO_I_SEARCH_ORDERS_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_I_SEARCH_ORDERS_V

View Text

SELECT OH.HEADER_ID
, OH.LAST_UPDATE_DATE
, OH.CREATION_DATE
, OH.ORDER_NUMBER
, OH.VERSION_NUMBER
, OH.ORDERED_DATE
, OH.SOLD_TO_ORG_ID
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, NULL
, NULL
, OH.TRANSACTIONAL_CURR_CODE
, OH.CUST_PO_NUMBER
, OH.SOLD_TO_CONTACT_ID
, CONT.FIRST_NAME SOLD_TO_CONTACT_FIRST_NAME
, CONT.LAST_NAME SOLD_TO_CONTACT_LAST_NAME
, ASO_ORDER_INT.GET_HEADER_STATUS(OH.HEADER_ID)
, ASO_ORDER_INT.TOTAL_ORDER_PRICE(OH.HEADER_ID)
FROM OE_ORDER_HEADERS_ALL OH
, HZ_CUST_ACCOUNTS ACCT
, RA_CUSTOMERS CUST
, RA_CONTACTS CONT
WHERE OH.SOLD_TO_ORG_ID = CUST.CUSTOMER_ID(+)
AND OH.SOLD_TO_CONTACT_ID = CONT.CONTACT_ID(+)

Columns