VIEW: APPS.OKL_AM_QUOTE_PARTIES_UV

Source

View Text - Preformatted

SELECT tq.id quote_id, tq.khr_id contract_id, qp.id qp_party_id, qp.qpt_code qp_role_code, lq.meaning qp_party_role, qp.date_sent qp_date_sent, to_char(NULL) qp_date_hold, QP.DELAY_DAYS QP_DELAY_DAYS, QP.ALLOCATION_PERCENTAGE QP_ALLOCATION_PERCENTAGE, QP.EMAIL_ADDRESS QP_EMAIL_ADDRESS, QP.PARTY_JTOT_OBJECT1_CODE QP_PARTY_OBJECT, QP.PARTY_OBJECT1_ID1 QP_PARTY_ID1, QP.PARTY_OBJECT1_ID2 QP_PARTY_ID2, QP.CONTACT_JTOT_OBJECT1_CODE QP_CONTACT_OBJECT, QP.CONTACT_OBJECT1_ID1 QP_CONTACT_ID1, QP.CONTACT_OBJECT1_ID2 QP_CONTACT_ID2, qp.CREATED_BY qp_created_by, qp.CREATION_DATE qp_creation_date, qp.LAST_UPDATED_BY qp_last_updated_by, qp.LAST_UPDATE_DATE qp_last_update_date, qp.LAST_UPDATE_LOGIN qp_last_update_login, pr.id kp_party_id, pr.rle_code kp_role_code, lk.meaning kp_party_role, pr.jtot_object1_code po_party_object, pr.object1_id1 po_party_id1, pr.object1_id2 po_party_id2, nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)) party_name, nvl2 (qp.contact_jtot_object1_code, okl_am_util_pvt.get_jtf_object_name (qp.contact_jtot_object1_code, qp.contact_object1_id1,qp.contact_object1_id2), null) contact_name FROM OKL_TRX_QUOTES_B TQ,OKL_QUOTE_PARTIES_V QP,OKC_K_PARTY_ROLES_V PR,FND_LOOKUPS LQ,FND_LOOKUPS LK WHERE qp.qte_id = tq.id AND pr.id (+) = qp.cpl_id AND lq.lookup_code (+) = qp.qpt_code AND lq.lookup_type (+) = 'OKL_QUOTE_PARTY_TYPE' AND lk.lookup_code (+) = pr.rle_code AND lk.lookup_type (+) = 'OKC_ROLE'

View Text - HTML Formatted

SELECT TQ.ID QUOTE_ID
, TQ.KHR_ID CONTRACT_ID
, QP.ID QP_PARTY_ID
, QP.QPT_CODE QP_ROLE_CODE
, LQ.MEANING QP_PARTY_ROLE
, QP.DATE_SENT QP_DATE_SENT
, TO_CHAR(NULL) QP_DATE_HOLD
, QP.DELAY_DAYS QP_DELAY_DAYS
, QP.ALLOCATION_PERCENTAGE QP_ALLOCATION_PERCENTAGE
, QP.EMAIL_ADDRESS QP_EMAIL_ADDRESS
, QP.PARTY_JTOT_OBJECT1_CODE QP_PARTY_OBJECT
, QP.PARTY_OBJECT1_ID1 QP_PARTY_ID1
, QP.PARTY_OBJECT1_ID2 QP_PARTY_ID2
, QP.CONTACT_JTOT_OBJECT1_CODE QP_CONTACT_OBJECT
, QP.CONTACT_OBJECT1_ID1 QP_CONTACT_ID1
, QP.CONTACT_OBJECT1_ID2 QP_CONTACT_ID2
, QP.CREATED_BY QP_CREATED_BY
, QP.CREATION_DATE QP_CREATION_DATE
, QP.LAST_UPDATED_BY QP_LAST_UPDATED_BY
, QP.LAST_UPDATE_DATE QP_LAST_UPDATE_DATE
, QP.LAST_UPDATE_LOGIN QP_LAST_UPDATE_LOGIN
, PR.ID KP_PARTY_ID
, PR.RLE_CODE KP_ROLE_CODE
, LK.MEANING KP_PARTY_ROLE
, PR.JTOT_OBJECT1_CODE PO_PARTY_OBJECT
, PR.OBJECT1_ID1 PO_PARTY_ID1
, PR.OBJECT1_ID2 PO_PARTY_ID2
, NVL2 (QP.CPL_ID
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (PR.JTOT_OBJECT1_CODE
, PR.OBJECT1_ID1
, PR.OBJECT1_ID2)
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (QP.PARTY_JTOT_OBJECT1_CODE
, QP.PARTY_OBJECT1_ID1
, QP.PARTY_OBJECT1_ID2)) PARTY_NAME
, NVL2 (QP.CONTACT_JTOT_OBJECT1_CODE
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME (QP.CONTACT_JTOT_OBJECT1_CODE
, QP.CONTACT_OBJECT1_ID1
, QP.CONTACT_OBJECT1_ID2)
, NULL) CONTACT_NAME
FROM OKL_TRX_QUOTES_B TQ
, OKL_QUOTE_PARTIES_V QP
, OKC_K_PARTY_ROLES_V PR
, FND_LOOKUPS LQ
, FND_LOOKUPS LK
WHERE QP.QTE_ID = TQ.ID
AND PR.ID (+) = QP.CPL_ID
AND LQ.LOOKUP_CODE (+) = QP.QPT_CODE
AND LQ.LOOKUP_TYPE (+) = 'OKL_QUOTE_PARTY_TYPE'
AND LK.LOOKUP_CODE (+) = PR.RLE_CODE
AND LK.LOOKUP_TYPE (+) = 'OKC_ROLE'