eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 29: Quantity available is calculated as JAI_CMN_RG_23D_TRXS.quantity_received - quantity that is matched, but it not

25: errbuf, p_organization_id, p_customer_id, p_order_type_id, p_delivery_id,
26: p_delivery_detail_id, p_order_header_id, p_line_number
27:
28: 2 13/12/2002 cbabu for Bug# 2689425, FileVersion# 615.2
29: Quantity available is calculated as JAI_CMN_RG_23D_TRXS.quantity_received - quantity that is matched, but it not
30: including the RTV quantity, that is calculating wrongly. Changes made
31: Quantity Available is modified to be calculated as
32: ( JAI_CMN_RG_23D_TRXS.qty_to_adjust - deliver quantity matched with receipt but not ship confirmed )
33:

Line 32: ( JAI_CMN_RG_23D_TRXS.qty_to_adjust - deliver quantity matched with receipt but not ship confirmed )

28: 2 13/12/2002 cbabu for Bug# 2689425, FileVersion# 615.2
29: Quantity available is calculated as JAI_CMN_RG_23D_TRXS.quantity_received - quantity that is matched, but it not
30: including the RTV quantity, that is calculating wrongly. Changes made
31: Quantity Available is modified to be calculated as
32: ( JAI_CMN_RG_23D_TRXS.qty_to_adjust - deliver quantity matched with receipt but not ship confirmed )
33:
34: 3. 08-Jun-2005 Version 116.2 jai_cmn_rcv_mach -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
35: as required for CASE COMPLAINCE.
36:

Line 104: SELECT * FROM JAI_CMN_RG_23D_TRXS

100: --then it becomes a performance issue.
101: CURSOR c_receipts_for_item( p_organization_id IN NUMBER,
102: p_location_id IN NUMBER,
103: p_inventory_item_id IN NUMBER) IS
104: SELECT * FROM JAI_CMN_RG_23D_TRXS
105: WHERE organization_id = p_organization_id
106: AND location_id = p_location_id
107: AND inventory_item_id = p_inventory_item_id
108: AND qty_to_adjust > 0

Line 531: FROM JAI_CMN_RG_23D_TRXS

527: -- WHERE Customer_Trx_Line_Id = p_ref_line_id;
528:
529: CURSOR Excise_Duty_Rate_Cur IS
530: SELECT rate_per_unit ,PRIMARY_UOM_CODE
531: FROM JAI_CMN_RG_23D_TRXS
532: WHERE register_id = p_receipt_id;
533:
534: Cursor C_op_dtl is
535: Select order_um1,exchange_rate,item_id

Line 1164: from JAI_CMN_RG_23D_TRXS

1160: AND c.tax_id = b.tax_id
1161: AND (c.shipment_line_id,a.line_location_id) = (SELECT shipment_line_id,po_line_location_id
1162: FROM rcv_transactions
1163: WHERE transaction_id = (select receipt_ref
1164: from JAI_CMN_RG_23D_TRXS
1165: where register_id = p_receipt_id))
1166: ORDER BY c.tax_line_no;
1167: --End addition by Vijay on 09-Oct-2001 for TAR# 9445972.700
1168:

Line 1651: FROM JAI_CMN_RG_23D_TRXS

1647: -- ssumaith - removed the + additional_cvd in the above line
1648: receipt_num ,
1649: decode(quantity_received ,0,1,quantity_received) quantity_received -- ,
1650: --other_tax_credit / decode(quantity_received ,0,1,quantity_received) -- bug#4111609
1651: FROM JAI_CMN_RG_23D_TRXS
1652: WHERE register_id = p_receipt_id;
1653:
1654: CURSOR cur_cess_Duty_Rate_Cur IS/*Bug 5989740 bduvarag*/
1655: SELECT tax_type , credit

Line 1696: FROM JAI_CMN_RG_23D_TRXS

1692:
1693:
1694: CURSOR c_ed_cess_tax_check(cp_shipment_line_id IN NUMBER) IS
1695: SELECT 1
1696: FROM JAI_CMN_RG_23D_TRXS
1697: WHERE register_id = p_transaction_id
1698: AND nvl(other_tax_credit,0) <> 0;
1699:
1700: ln_order_line_id NUMBER(15);

Line 1824: Here if the other_tax_credit in jai_cmn_rg_23d_trxs is <> 0 then the tax_rate and precedences can be assigned as null

1820: Excise Education cess taxes are not being recalculated correctly in some cases.
1821:
1822: Reason:-
1823: This is a enhancement to the existing education cess code
1824: Here if the other_tax_credit in jai_cmn_rg_23d_trxs is <> 0 then the tax_rate and precedences can be assigned as null
1825: and the tax rate need not be considered.
1826: However if the other_tax_credit in jai_cmn_rg_23d_trxs is = 0 then the tax rate needs to be considered for recalculation.
1827:
1828: Fix:-

Line 1826: However if the other_tax_credit in jai_cmn_rg_23d_trxs is = 0 then the tax rate needs to be considered for recalculation.

1822: Reason:-
1823: This is a enhancement to the existing education cess code
1824: Here if the other_tax_credit in jai_cmn_rg_23d_trxs is <> 0 then the tax_rate and precedences can be assigned as null
1825: and the tax rate need not be considered.
1826: However if the other_tax_credit in jai_cmn_rg_23d_trxs is = 0 then the tax rate needs to be considered for recalculation.
1827:
1828: Fix:-
1829: Modified the code to set the tax rate and precedences according to the other_tax_rate column in jai_cmn_rg_23d_trxs based on a IF condition.
1830:

Line 1829: Modified the code to set the tax rate and precedences according to the other_tax_rate column in jai_cmn_rg_23d_trxs based on a IF condition.

1825: and the tax rate need not be considered.
1826: However if the other_tax_credit in jai_cmn_rg_23d_trxs is = 0 then the tax rate needs to be considered for recalculation.
1827:
1828: Fix:-
1829: Modified the code to set the tax rate and precedences according to the other_tax_rate column in jai_cmn_rg_23d_trxs based on a IF condition.
1830:
1831: Dependency Introduced due to this bug:-
1832: None
1833: 8 08/05/2007 Made changes for InterOrg bug 6030615

Line 2396: ||other_tax_credit in jai_cmn_rg_23d_trxs is not null

2392: || Code modified by aiyer for the bug 4539813
2393: */
2394: IF nvl(ln_cess_duty_rate,0) <> 0 THEN
2395: /*
2396: ||other_tax_credit in jai_cmn_rg_23d_trxs is not null
2397: */
2398: tax_rate_tab(rec.lno) := -1;
2399: P1(rec.lno) := -1;
2400: P2(rec.lno) := -1;