APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 7316: AND p_source_table = 'OKL_TXD_AR_LN_DTLS_B'

7312: l_fin_prod_id_det := NULL; -- financial product is NA for repurchase quote creation, updation
7313: l_int_disclosed_det := 'N';
7314: END IF;
7315: ELSIF ( (p_source_trx_name = 'Billing' OR p_source_trx_name = 'Credit Memo')
7316: AND p_source_table = 'OKL_TXD_AR_LN_DTLS_B'
7317: ) THEN -- Billing from other transactions (not stream biling)
7318: IF p_qtp_code LIKE 'TER%' THEN -- termination quote billing
7319: IF p_early_term_yn = 'Y' THEN
7320: -- get Early term purchase option

Line 7809: AND ( p_source_table = 'OKL_TXD_AR_LN_DTLS_B' )

7805:
7806: IF ( (p_source_trx_name IS NULL AND p_source_table = 'OKL_TRX_QUOTES_B' AND p_qtp_code LIKE 'REP%')-- Repurchase quote creation/updation
7807: OR
7808: ( ( p_source_trx_name = 'Billing' OR p_source_trx_name = 'Credit Memo' )
7809: AND ( p_source_table = 'OKL_TXD_AR_LN_DTLS_B' )
7810: AND ( p_qtp_code LIKE 'REP%' OR p_purpose_code IN ('AMBSPR','CURE','REPAIR_CHARGE') )
7811: ) -- Repurchase quote billing OR Remk,asset repair or vendor cure billing
7812: ) THEN
7813:

Line 8253: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line, okl_txd_ar_ln_dtls_b det

8249:
8250: -- get the billing line details
8251: CURSOR l_txdarlndtls_csr(cp_sel_id IN NUMBER, cp_sty_id IN NUMBER) IS
8252: SELECT hdr.id trx_id, det.id trx_line_id
8253: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line, okl_txd_ar_ln_dtls_b det
8254: WHERE det.sel_id = cp_sel_id
8255: AND det.sty_id = cp_sty_id
8256: AND det.til_id_details = line.id
8257: AND line.tai_id = hdr.id;

Line 18900: | p_source_trx_id -- OKL_TXD_AR_LN_DTLS_B.ID

18896: | okl_am_util_pvt.get_formula_value()
18897: |
18898: | PARAMETERS
18899: | - Billing
18900: | p_source_trx_id -- OKL_TXD_AR_LN_DTLS_B.ID
18901: | p_source_trx_name -- Billing / Credit Memo transaction
18902: | p_source_table -- OKL_TXD_AR_LN_DTLS_B
18903: | - P2P
18904: | p_source_trx_id -- OKL_TXL_AP_INV_LNS_ALL_B.ID

Line 18902: | p_source_table -- OKL_TXD_AR_LN_DTLS_B

18898: | PARAMETERS
18899: | - Billing
18900: | p_source_trx_id -- OKL_TXD_AR_LN_DTLS_B.ID
18901: | p_source_trx_name -- Billing / Credit Memo transaction
18902: | p_source_table -- OKL_TXD_AR_LN_DTLS_B
18903: | - P2P
18904: | p_source_trx_id -- OKL_TXL_AP_INV_LNS_ALL_B.ID
18905: | p_source_trx_name -- Funding / Disbursements transaction
18906: | p_source_table -- OKL_TXL_AP_INV_LNS_ALL_B

Line 18938: okl_txd_ar_ln_dtls_b det

18934: SELECT hdr.id hdr_id, hdr.khr_id, hdr.date_invoiced, hdr.try_id try_id,
18935: hdr.qte_id, hdr.ibt_id , hdr.legal_entity_id, line.id line_id, line.kle_id,
18936: line.isl_id, det.sty_id, det.amount
18937: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line,
18938: okl_txd_ar_ln_dtls_b det
18939: WHERE det.id = cp_det_line_id
18940: AND det.til_id_details = line.id
18941: AND line.tai_id = hdr.id;
18942: