View: ASO_I_ORDER_HEADERS_BALI_V

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

View Text

SELECT OH.ORDER_NUMBER
, ASO_ORDER_INT.GET_ORDER_TOTAL(OH.HEADER_ID
, NULL)
, OH.ORDERED_DATE
, ACCT.PARTY_ID
, OH.SOLD_TO_ORG_ID
, OH.HEADER_ID
, QH.QUOTE_NAME
, QH.QUOTE_NUMBER||'-'||QH.QUOTE_VERSION
, LKP.MEANING
, QH.QUOTE_HEADER_ID
, ACCT.ACCOUNT_NUMBER
, OH.TRANSACTIONAL_CURR_CODE
, APP.PARTY_NAME
, QH.RESOURCE_ID
, SRP.NAME
, QH.PARTY_ID
, APP.PARTY_TYPE
FROM OE_ORDER_HEADERS_ALL OH
, ASO_QUOTE_HEADERS_ALL QH
, HZ_CUST_ACCOUNTS ACCT
, ASO_PVT_PARTIES_V APP
, ASO_PVT_PARTY_RLTN_V APPR
, JTF_RS_SRP_VL SRP
, OE_LOOKUPS LKP
WHERE OH.HEADER_ID = QH.ORDER_ID(+)
AND OH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID
AND QH.PARTY_ID=APPR.PARTY_ID(+)
AND APPR.SUBJECT_ID=APP.PARTY_ID(+)
AND SRP.RESOURCE_ID(+) = QH.RESOURCE_ID
AND LKP.LOOKUP_CODE = OH.FLOW_STATUS_CODE
AND LOOKUP_TYPE = 'FLOW_STATUS'
AND NVL(SRP.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND NVL(QH.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns