VIEW: APPS.ASO_PVT_CUST_QUOTE_HDRS_BALI_V

Source

View Text - Preformatted

SELECT QTE.QUOTE_NAME, QTE.QUOTE_NUMBER, QTE.QUOTE_NUMBER||'-'||QTE.QUOTE_VERSION, QTE.CREATION_DATE, NULL , nvl(QTE.TOTAL_QUOTE_PRICE, 0.0), QTE.QUOTE_EXPIRATION_DATE, NULL , QTE.QUOTE_HEADER_ID, QTE.CUST_ACCOUNT_ID, qte.cust_party_id , QTE.CURRENCY_CODE, NULL , qte.resource_id , NULL , qte.party_id , NULL , qte.quote_status_id, ou.name operating_unit, qte.org_id FROM aso_quote_headers_all QTE, (select organization_id,name from hr_operating_units where mo_global.check_access(organization_id)='Y') OU WHERE OU.organization_id=qte.org_id

View Text - HTML Formatted

SELECT QTE.QUOTE_NAME
, QTE.QUOTE_NUMBER
, QTE.QUOTE_NUMBER||'-'||QTE.QUOTE_VERSION
, QTE.CREATION_DATE
, NULL
, NVL(QTE.TOTAL_QUOTE_PRICE
, 0.0)
, QTE.QUOTE_EXPIRATION_DATE
, NULL
, QTE.QUOTE_HEADER_ID
, QTE.CUST_ACCOUNT_ID
, QTE.CUST_PARTY_ID
, QTE.CURRENCY_CODE
, NULL
, QTE.RESOURCE_ID
, NULL
, QTE.PARTY_ID
, NULL
, QTE.QUOTE_STATUS_ID
, OU.NAME OPERATING_UNIT
, QTE.ORG_ID
FROM ASO_QUOTE_HEADERS_ALL QTE
, (SELECT ORGANIZATION_ID
, NAME
FROM HR_OPERATING_UNITS
WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID)='Y') OU
WHERE OU.ORGANIZATION_ID=QTE.ORG_ID