APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 200: jai_cmn_taxes_all jtc

196: nvl(rtl.currency_code, 'INR') currency,
197: nvl(jtc.mod_cr_percentage, 0) mod_cr_percentage
198: FROM
199: jai_cmn_document_taxes rtl,
200: jai_cmn_taxes_all jtc
201: WHERE
202: source_doc_line_id = p_source_line_id
203: AND jtc.tax_id = rtl.tax_id
204: AND source_doc_type = 'INTERORG_XFER'

Line 873: jai_cmn_taxes_all jtc,

869: sum(jcdt.tax_amt) tax_amt
870: FROM
871: jai_mtl_trxs jmt,
872: jai_cmn_document_taxes jcdt,
873: jai_cmn_taxes_all jtc,
874: jai_rgm_registrations jrg,
875: jai_rgm_definitions jrr
876: WHERE
877: jmt.to_organization = p_organization_id

Line 1402: jai_cmn_taxes_all B,

1398: d.to_subinventory ,
1399: d.location_id,
1400: d.inventory_item_id
1401: FROM Jai_cmn_document_Taxes A,
1402: jai_cmn_taxes_all B,
1403: jai_mtl_trxs D,
1404: jai_regime_tax_types_v aa
1405: WHERE source_doc_line_id = p_transaction_temp_id
1406: AND d.transaction_temp_id = p_transaction_temp_id

Line 4358: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,

4354: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
4355: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
4356: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
4357: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
4358: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
4359: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
4360: p_receipt_num IN VARCHAR2,
4361: P_applied_qty IN NUMBER,
4362: p_organization_id IN NUMBER,

Line 4359: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,

4355: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
4356: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
4357: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
4358: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
4359: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
4360: p_receipt_num IN VARCHAR2,
4361: P_applied_qty IN NUMBER,
4362: p_organization_id IN NUMBER,
4363: p_inventory_item_id IN NUMBER,

Line 4425: jai_cmn_taxes_all b,

4421: a.tax_id,
4422: NVL(b.rounding_factor,0) rounding_factor,
4423: c.qty_received
4424: FROM JAI_RCV_LINE_TAXES a,
4425: jai_cmn_taxes_all b,
4426: jai_rcv_lines c
4427: WHERE a.shipment_line_id =c.shipment_line_id
4428: AND a.shipment_line_id = cp_shipment_line_id
4429: AND a.tax_type IN ( select tax_type