APPS.OKL_AM_QUOTES_WF dependencies on OKL_AM_QUOTE_PARTIES_UV

Line 4077: OKL_AM_QUOTE_PARTIES_UV b

4073: a.QTE_ID QTE_ID,
4074: b.PO_PARTY_ID1 QP_PARTY_ID,
4075: decode(b.po_party_object, 'OKX_OPERUNIT', 'O', 'OKX_PARTY', 'P', 'OKX_VENDOR', 'V') party_type
4076: FROM OKL_TXL_QUOTE_LINES_V a,
4077: OKL_AM_QUOTE_PARTIES_UV b
4078: WHERE a.qte_id = to_number(p_qte_id)
4079: -- and b.qp_role_code = 'RECIPIENT'
4080: and b.quote_id = a.qte_id;
4081:

Line 4867: OKL_AM_QUOTE_PARTIES_UV b

4863: a.QTE_ID QTE_ID,
4864: b.PO_PARTY_ID1 QP_PARTY_ID,
4865: decode(b.po_party_object, 'OKX_OPERUNIT', 'O', 'OKX_PARTY', 'P', 'OKX_VENDOR', 'V') party_type
4866: FROM OKL_TXL_QUOTE_LINES_V a,
4867: OKL_AM_QUOTE_PARTIES_UV b
4868: WHERE a.qte_id = to_number(p_qte_id)
4869: -- and b.qp_role_code = 'RECIPIENT'
4870: and b.quote_id = a.qte_id;
4871:

Line 6187: FROM OKL_AM_QUOTE_PARTIES_UV

6183: l_delay_days NUMBER(10,4);
6184:
6185: CURSOR c_delay_days_csr(c_qte_id NUMBER) IS
6186: SELECT max(QP_DELAY_DAYS) DELAY_DAYS
6187: FROM OKL_AM_QUOTE_PARTIES_UV
6188: WHERE quote_id = c_qte_id
6189: AND qp_role_code = 'ADVANCE_NOTICE';
6190:
6191: API_ERROR EXCEPTION;