View: ASO_I_QUOTE_HEADERS_BALI_V

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

View Text

SELECT QTE.QUOTE_NAME
, QTE.QUOTE_NUMBER||'-'||QTE.QUOTE_VERSION
, QTE.CREATION_DATE
, STA.MEANING
, NVL(QTE.TOTAL_QUOTE_PRICE
, 0.0)
, QTE.QUOTE_EXPIRATION_DATE
, ACCT.ACCOUNT_NUMBER
, QTE.QUOTE_HEADER_ID
, QTE.CUST_ACCOUNT_ID
, ACCT.PARTY_ID
, QTE.CURRENCY_CODE
, APP.PARTY_NAME
, QTE.RESOURCE_ID
, SRP.NAME
, QTE.PARTY_ID
, APP.PARTY_TYPE
FROM ASO_QUOTE_HEADERS_ALL QTE
, ASO_QUOTE_STATUSES_VL STA
, HZ_CUST_ACCOUNTS ACCT
, ASO_PVT_PARTIES_V APP
, ASO_PVT_PARTY_RLTN_V APPR
, JTF_RS_SRP_VL SRP
WHERE QTE.QUOTE_STATUS_ID = STA.QUOTE_STATUS_ID
AND (TRUNC(SYSDATE) BETWEEN NVL(TRUNC(STA.EFFECTIVE_START_DATE)
, TRUNC (SYSDATE))
AND NVL(TRUNC(STA.EFFECTIVE_END_DATE)
, TRUNC(SYSDATE)))
AND QTE.CUST_ACCOUNT_ID = ACCT.CUST_ACCOUNT_ID(+)
AND QTE.PARTY_ID = APPR.PARTY_ID(+)
AND APPR.SUBJECT_ID = APP.PARTY_ID(+)
AND SRP.RESOURCE_ID(+) = QTE.RESOURCE_ID
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(QTE.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