Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_LM_QUOTES_V |
SELECT DISTINCT PARTY.PARTY_NAME
, REPS.NAME
, QTE.QUOTE_NAME
, QTE.QUOTE_NUMBER
, QTE.QUOTE_VERSION
, STA.MEANING
, STA.STATUS_CODE
, QTE.QUOTE_EXPIRATION_DATE
, ORD.ORDER_NUMBER
, ORD.ORDERED_DATE
, ACCT.ACCOUNT_NUMBER
, QTE.QUOTE_HEADER_ID
, QTE.CUST_ACCOUNT_ID
, QTE.PARTY_ID
, QTE.ATTRIBUTE1
, QTE.ATTRIBUTE2
, QTE.ATTRIBUTE3
, QTE.ATTRIBUTE4
, QTE.ATTRIBUTE5
, QTE.ATTRIBUTE6
, QTE.ATTRIBUTE7
, QTE.ATTRIBUTE8
, QTE.ATTRIBUTE9
, QTE.ATTRIBUTE10
, QTE.ATTRIBUTE11
, QTE.ATTRIBUTE12
, QTE.ATTRIBUTE13
, QTE.ATTRIBUTE14
, QTE.ATTRIBUTE15
, PART.PERSON_FIRST_NAME
, PART.PERSON_LAST_NAME
, PART.PARTY_NAME
, NVL(QTE.TOTAL_QUOTE_PRICE
, 0.0)
, QTE.CURRENCY_CODE
, QTE.ORG_ID
, HR.NAME
FROM ASO_QUOTE_HEADERS_ALL QTE
, OE_ORDER_HEADERS_ALL ORD
, ASO_QUOTE_STATUSES_VL STA
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES PARTY
, JTF_RS_SALESREPS REPS
, HZ_RELATIONSHIPS REL
, HZ_PARTIES PART
, HR_OPERATING_UNITS HR
WHERE QTE.ORDER_ID = ORD.HEADER_ID(+)
AND QTE.QUOTE_STATUS_ID = STA.QUOTE_STATUS_ID
AND QTE.CUST_ACCOUNT_ID = ACCT.CUST_ACCOUNT_ID(+)
AND QTE.PARTY_ID = PARTY.PARTY_ID(+)
AND QTE.ORG_ID = ORD.ORG_ID(+)
AND QTE.ORG_ID = HR.ORGANIZATION_ID
AND PARTY.STATUS IN('A'
, 'I')
AND QTE.RESOURCE_ID = REPS.RESOURCE_ID(+)
AND PARTY.PARTY_ID = REL.PARTY_ID(+)
AND REL.SUBJECT_TYPE(+) = 'PERSON'
AND REL.OBJECT_TYPE(+) = 'ORGANIZATION'
AND REL.SUBJECT_ID = PART.PARTY_ID (+)