VIEW: APPS.AST_LM_QUOTES_V

Source

View Text - Preformatted

SELECT distinct NVL(ORG.PARTY_NAME , PARTY.PARTY_NAME), 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 , NVL(REL.OBJECT_ID, QTE.PARTY_ID) ORG_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, HZ_PARTIES ORG, 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 (+) AND REL.OBJECT_ID = ORG.PARTY_ID (+)

View Text - HTML Formatted

SELECT DISTINCT NVL(ORG.PARTY_NAME
, PARTY.PARTY_NAME)
, 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
, NVL(REL.OBJECT_ID
, QTE.PARTY_ID) ORG_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
, HZ_PARTIES ORG
, 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 (+)
AND REL.OBJECT_ID = ORG.PARTY_ID (+)