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_INV_MMT_TRIGGER_PKG dependencies on JAI_CMN_RG_I_TRXS_S

Line 1066: JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno1,round( ABS(v_manu_qty),5),

1062: inventory_item_id, organization_id, transaction_type, range_no,
1063: division_no, location_id, transaction_uom_code, transaction_date,
1064: primary_uom_code, REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
1065: ) VALUES (
1066: JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno1,round( ABS(v_manu_qty),5),
1067: round(ABS(v_manu_pkd_qty),5), round(ABS(v_manu_loose_qty),5),round( v_bal_packed,5), round(v_bal_loose,5), --abs(v_trans_qty), commented by Sriram on 26-Dec-2001
1068: NULL, -- abs(v_t_qty), commented by Sriram on 26-Dec-2001
1069: NULL, round(ABS(v_trans_qty),5), pr_new.last_update_date, pr_new.last_updated_by,
1070: SYSDATE, pr_new.created_by, pr_new.last_update_login, v_temp_trans_type_id,

Line 1644: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno, round(ABS(v_manu_qty),5),

1640: transaction_type, range_no, division_no, location_id,
1641: transaction_uom_code, transaction_date,
1642: primary_uom_code,
1643: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
1644: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno, round(ABS(v_manu_qty),5),
1645: round(ABS(v_manu_pkd_qty),5), round(ABS(v_manu_loose_qty),5),
1646: round(v_bal_packed,5), round(v_bal_loose,5),
1647: round(ABS (v_trans_qty),5),
1648: round(v_t_qty,5), pr_new.last_update_date,

Line 1863: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno, round(ABS(v_manu_qty),5),

1859: transaction_type, range_no, division_no, location_id,
1860: transaction_uom_code, transaction_date,
1861: primary_uom_code,
1862: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
1863: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno, round(ABS(v_manu_qty),5),
1864: round(ABS(v_manu_pkd_qty),5),round( ABS(v_manu_loose_qty),5),
1865: round(v_bal_packed,5), round(v_bal_loose,5),
1866: round(ABS (v_hit_rg1_qty),5),
1867: round(v_t_qty,5), pr_new.last_update_date,

Line 2248: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,

2244: range_no, division_no, location_id,
2245: transaction_uom_code, transaction_date,
2246: primary_uom_code,
2247: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
2248: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2249: round(v_manufactured_qty,5), round(v_manufactured_pack_qty,5),
2250: round(v_manu_loose_qty,5), round(v_bal_packed,5), round(v_bal_loose,5), -- v_manu_loose_qty changed to null by sriram bug # 3258086on product management advice.
2251: round(v_oth_pur_npe_qty,5), v_oth_purpose,
2252: round(v_other_npe_qty,5), NULL, --earlier 'PI' corresponding field is number -- put v_manu_loose_qty instead of v_trans_qty - sriram

Line 2488: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,

2484: range_no, division_no, location_id,
2485: transaction_uom_code, transaction_date,
2486: primary_uom_code,
2487: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
2488: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2489: round(v_manufactured_qty,5), round(v_manufactured_pack_qty,5),
2490: Null, round(v_bal_packed,5), round(v_bal_loose,5), -- v_manu_loose_qty set to null by sriram - bug # 3258066 based on product management advice.
2491: round(v_oth_pur_npe_qty,5), v_oth_purpose,
2492: round( v_manu_loose_qty,5), NULL, --earlier 'PI' corresponding field is number -- v_trans_qty changed to v_manu_loose_qty by sriram - bug # 3258066 based on p.m advice.

Line 2863: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,

2859: transaction_type, range_no, division_no, location_id,
2860: transaction_uom_code, transaction_date,
2861: primary_uom_code,
2862: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
2863: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2864: round(v_manufactured_qty,5), round(v_manufactured_pack_qty,5),
2865: round(v_manu_loose_qty,5), round( v_bal_packed,5),
2866: round( v_bal_loose,5), round( v_trans_qty,5),
2867: round(v_t_qty,5), pr_new.last_update_date,