APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 323: jai_cmn_taxes_all jtc

319: nvl(rtl.currency_code, 'INR') currency,
320: nvl(jtc.mod_cr_percentage, 0) mod_cr_percentage
321: FROM
322: jai_cmn_document_taxes rtl,
323: jai_cmn_taxes_all jtc
324: WHERE
325: source_doc_line_id = p_source_line_id
326: AND jtc.tax_id = rtl.tax_id
327: AND source_doc_type = 'INTERORG_XFER'

Line 996: jai_cmn_taxes_all jtc,

992: sum(jcdt.tax_amt) tax_amt
993: FROM
994: jai_mtl_trxs jmt,
995: jai_cmn_document_taxes jcdt,
996: jai_cmn_taxes_all jtc,
997: jai_rgm_registrations jrg,
998: jai_rgm_definitions jrr
999: WHERE
1000: jmt.to_organization = p_organization_id

Line 1530: jai_cmn_taxes_all B,

1526: d.to_subinventory ,
1527: d.location_id,
1528: d.inventory_item_id
1529: FROM Jai_cmn_document_Taxes A,
1530: jai_cmn_taxes_all B,
1531: jai_mtl_trxs D,
1532: jai_regime_tax_types_v aa
1533: WHERE source_doc_line_id = p_transaction_temp_id
1534: AND d.transaction_temp_id = p_transaction_temp_id

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

4799: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
4800: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
4801: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
4802: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
4803: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
4804: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
4805: p_receipt_num IN VARCHAR2,
4806: P_applied_qty IN NUMBER,
4807: p_organization_id IN NUMBER,

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

4800: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
4801: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
4802: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
4803: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
4804: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
4805: p_receipt_num IN VARCHAR2,
4806: P_applied_qty IN NUMBER,
4807: p_organization_id IN NUMBER,
4808: p_inventory_item_id IN NUMBER,

Line 4867: jai_cmn_taxes_all b,

4863: a.tax_id,
4864: NVL(b.rounding_factor,0) rounding_factor,
4865: c.qty_received
4866: FROM JAI_RCV_LINE_TAXES a,
4867: jai_cmn_taxes_all b,
4868: jai_rcv_lines c
4869: WHERE a.shipment_line_id =c.shipment_line_id
4870: AND a.shipment_line_id = cp_shipment_line_id
4871: AND a.tax_type IN ( select tax_type