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 163: SELECT * FROM JAI_CMN_RG_23D_TRXS

159: --then it becomes a performance issue.
160: CURSOR c_receipts_for_item( p_organization_id IN NUMBER,
161: p_location_id IN NUMBER,
162: p_inventory_item_id IN NUMBER) IS
163: SELECT * FROM JAI_CMN_RG_23D_TRXS
164: WHERE organization_id = p_organization_id
165: AND location_id = p_location_id
166: AND inventory_item_id = p_inventory_item_id
167: AND qty_to_adjust > 0

Line 590: FROM JAI_CMN_RG_23D_TRXS

586: -- WHERE Customer_Trx_Line_Id = p_ref_line_id;
587:
588: CURSOR Excise_Duty_Rate_Cur IS
589: SELECT rate_per_unit ,PRIMARY_UOM_CODE
590: FROM JAI_CMN_RG_23D_TRXS
591: WHERE register_id = p_receipt_id;
592:
593: Cursor C_op_dtl is
594: Select order_um1,exchange_rate,item_id

Line 1223: from JAI_CMN_RG_23D_TRXS

1219: AND c.tax_id = b.tax_id
1220: AND (c.shipment_line_id,a.line_location_id) = (SELECT shipment_line_id,po_line_location_id
1221: FROM rcv_transactions
1222: WHERE transaction_id = (select receipt_ref
1223: from JAI_CMN_RG_23D_TRXS
1224: where register_id = p_receipt_id))
1225: ORDER BY c.tax_line_no;
1226: --End addition by Vijay on 09-Oct-2001 for TAR# 9445972.700
1227:

Line 1746: FROM JAI_CMN_RG_23D_TRXS

1742: -- ssumaith - removed the + additional_cvd in the above line
1743: receipt_num ,
1744: decode(DECODE( TRANSACTION_TYPE, 'MCR', oth_receipt_quantity,quantity_received) ,0,1,DECODE( TRANSACTION_TYPE, 'MCR', oth_receipt_quantity,quantity_received)) quantity_received -- added the decode transaction_type for bug8366387 ,
1745: --other_tax_credit / decode(quantity_received ,0,1,quantity_received) -- bug#4111609
1746: FROM JAI_CMN_RG_23D_TRXS
1747: WHERE register_id = p_receipt_id;
1748:
1749: CURSOR cur_cess_Duty_Rate_Cur IS/*Bug 5989740 bduvarag*/
1750: SELECT tax_type , credit

Line 1791: FROM JAI_CMN_RG_23D_TRXS

1787:
1788:
1789: CURSOR c_ed_cess_tax_check(cp_shipment_line_id IN NUMBER) IS
1790: SELECT 1
1791: FROM JAI_CMN_RG_23D_TRXS
1792: WHERE register_id = p_transaction_id
1793: AND nvl(other_tax_credit,0) <> 0;
1794:
1795: ln_order_line_id NUMBER(15);

Line 1919: 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

1915: Excise Education cess taxes are not being recalculated correctly in some cases.
1916:
1917: Reason:-
1918: This is a enhancement to the existing education cess code
1919: 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
1920: and the tax rate need not be considered.
1921: However if the other_tax_credit in jai_cmn_rg_23d_trxs is = 0 then the tax rate needs to be considered for recalculation.
1922:
1923: Fix:-

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

1917: Reason:-
1918: This is a enhancement to the existing education cess code
1919: 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
1920: and the tax rate need not be considered.
1921: However if the other_tax_credit in jai_cmn_rg_23d_trxs is = 0 then the tax rate needs to be considered for recalculation.
1922:
1923: Fix:-
1924: 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.
1925:

Line 1924: 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.

1920: and the tax rate need not be considered.
1921: However if the other_tax_credit in jai_cmn_rg_23d_trxs is = 0 then the tax rate needs to be considered for recalculation.
1922:
1923: Fix:-
1924: 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.
1925:
1926: Dependency Introduced due to this bug:-
1927: None
1928: 8 08/05/2007 Made changes for InterOrg bug 6030615

Line 2561: ||other_tax_credit in jai_cmn_rg_23d_trxs is not null

2557: || Code modified by aiyer for the bug 4539813
2558: */
2559: IF nvl(ln_cess_duty_rate,0) <> 0 THEN
2560: /*
2561: ||other_tax_credit in jai_cmn_rg_23d_trxs is not null
2562: */
2563: tax_rate_tab(rec.lno) := -1;
2564: P1(rec.lno) := -1;
2565: P2(rec.lno) := -1;