APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_AR_TRXS

Line 500: JAI_AR_TRXS jtrx ,

496: decode(upper(trx_types.type),cp_invoice_type,nvl(jtc.mod_cr_percentage,0),100) mod_cr_percentage ,
497: jtrxtl.link_to_cust_trx_line_id
498: FROM
499: ra_customer_trx_all trx ,
500: JAI_AR_TRXS jtrx ,
501: ra_cust_trx_types_all trx_types ,
502: JAI_AR_TRX_LINES jtrxl ,
503: JAI_AR_TRX_TAX_LINES jtrxtl ,
504: JAI_CMN_TAXES_ALL jtc

Line 1200: JAI_AR_TRXS inv_jtrx ,

1196: ar_receivable_applications_all aral ,
1197: ra_customer_trx_all cm_trx ,
1198: ra_customer_trx_all inv_trx ,
1199: ra_cust_trx_types_all trx_types ,
1200: JAI_AR_TRXS inv_jtrx ,
1201: JAI_AR_TRXS cm_jtrx
1202: WHERE
1203: aral.customer_trx_id = cm_trx.customer_trx_id AND
1204: cm_trx.customer_trx_id = cm_jtrx.customer_trx_id AND

Line 1201: JAI_AR_TRXS cm_jtrx

1197: ra_customer_trx_all cm_trx ,
1198: ra_customer_trx_all inv_trx ,
1199: ra_cust_trx_types_all trx_types ,
1200: JAI_AR_TRXS inv_jtrx ,
1201: JAI_AR_TRXS cm_jtrx
1202: WHERE
1203: aral.customer_trx_id = cm_trx.customer_trx_id AND
1204: cm_trx.customer_trx_id = cm_jtrx.customer_trx_id AND
1205: aral.applied_customer_trx_id = inv_trx.customer_trx_id AND

Line 1253: CURSOR cur_get_inv_tottax_amt (cp_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE)

1249:
1250: /*
1251: || Get the Total transactional tax amount for the invoice
1252: */
1253: CURSOR cur_get_inv_tottax_amt (cp_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE)
1254: IS
1255: SELECT
1256: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1257: FROM

Line 1283: ( pn_cm_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE

1279: --added by walton for inclusive tax 29-Nov-07
1280: -----------------------------------------------------
1281: --Get the Total CM inclusive tax amount for the cm,
1282: CURSOR cur_get_cm_inclusive_tax_amt
1283: ( pn_cm_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
1284: )
1285: IS
1286: SELECT
1287: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt

Line 1299: ( pn_cm_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE

1295: AND NVL(tax.inclusive_tax_flag,'N') = 'Y' ;
1296:
1297: --Get the Total CM line amount,
1298: CURSOR cur_get_cm_line_amt
1299: ( pn_cm_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
1300: )
1301: IS
1302: SELECT
1303: nvl(sum(jrtl.line_amount),0) inv_tot_line_amt

Line 1911: JAI_AR_TRXS jtrx

1907: ar_receivable_applications_all aral ,
1908: ar_cash_receipts_all acrl ,
1909: ra_customer_trx_all trx ,
1910: ra_cust_trx_types_all trx_types ,
1911: JAI_AR_TRXS jtrx
1912: WHERE
1913: aral.cash_receipt_id = acrl.cash_receipt_id AND
1914: aral.applied_customer_trx_id = trx.customer_trx_id AND
1915: trunc(aral.creation_date) BETWEEN trunc(p_from_date) and trunc(p_to_date) AND

Line 1958: CURSOR cur_get_inv_tottax_amt (cp_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE)

1954:
1955: /*
1956: || Get the Total transactional tax amount for the invoice
1957: */
1958: CURSOR cur_get_inv_tottax_amt (cp_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE)
1959: IS
1960: SELECT
1961: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1962: FROM

Line 1973: ( pn_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE

1969: --added by walton for inclusive tax 29-Nov-07
1970: ---------------------------------------------------------------
1971: --Get the Total inclusive tax amount for the invoice,
1972: CURSOR cur_get_inv_inclusive_tax_amt
1973: ( pn_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
1974: )
1975: IS
1976: SELECT
1977: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt

Line 1989: ( pn_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE

1985: AND NVL(tax.inclusive_tax_flag,'N') = 'Y' ;
1986:
1987: --Get the Total AR transaction line amount,
1988: CURSOR cur_get_inv_line_amt
1989: ( pn_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
1990: )
1991: IS
1992: SELECT
1993: nvl(sum(jrtl.line_amount),0) inv_tot_line_amt