DBA Data[Home] [Help]

APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on JAI_CMN_RG_I_TRXS_S

Line 967: JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno1, ABS(v_manu_qty),

963: inventory_item_id, organization_id, transaction_type, range_no,
964: division_no, location_id, transaction_uom_code, transaction_date,
965: primary_uom_code, REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
966: ) VALUES (
967: JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno1, ABS(v_manu_qty),
968: ABS(v_manu_pkd_qty), ABS(v_manu_loose_qty), v_bal_packed, v_bal_loose, --abs(v_trans_qty), commented by Sriram on 26-Dec-2001
969: NULL, -- abs(v_t_qty), commented by Sriram on 26-Dec-2001
970: NULL, ABS(v_trans_qty), pr_new.last_update_date, pr_new.last_updated_by,
971: SYSDATE, pr_new.created_by, pr_new.last_update_login, v_temp_trans_type_id,

Line 1481: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno, ABS(v_manu_qty),

1477: transaction_type, range_no, division_no, location_id,
1478: transaction_uom_code, transaction_date,
1479: primary_uom_code,
1480: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
1481: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno, ABS(v_manu_qty),
1482: ABS(v_manu_pkd_qty), ABS(v_manu_loose_qty),
1483: v_bal_packed, v_bal_loose,
1484: ABS (v_trans_qty),
1485: v_t_qty, pr_new.last_update_date,

Line 1665: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno, ABS(v_manu_qty),

1661: transaction_type, range_no, division_no, location_id,
1662: transaction_uom_code, transaction_date,
1663: primary_uom_code,
1664: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
1665: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno, ABS(v_manu_qty),
1666: ABS(v_manu_pkd_qty), ABS(v_manu_loose_qty),
1667: v_bal_packed, v_bal_loose,
1668: ABS (v_hit_rg1_qty),
1669: v_t_qty, pr_new.last_update_date,

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

2010: range_no, division_no, location_id,
2011: transaction_uom_code, transaction_date,
2012: primary_uom_code,
2013: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
2014: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2015: v_manufactured_qty, v_manufactured_pack_qty,
2016: v_manu_loose_qty, v_bal_packed, v_bal_loose, -- v_manu_loose_qty changed to null by sriram bug # 3258086on product management advice.
2017: v_oth_pur_npe_qty, v_oth_purpose,
2018: v_other_npe_qty, NULL, --earlier 'PI' corresponding field is number -- put v_manu_loose_qty instead of v_trans_qty - sriram

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

2215: range_no, division_no, location_id,
2216: transaction_uom_code, transaction_date,
2217: primary_uom_code,
2218: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
2219: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2220: v_manufactured_qty, v_manufactured_pack_qty,
2221: Null, v_bal_packed, v_bal_loose, -- v_manu_loose_qty set to null by sriram - bug # 3258066 based on product management advice.
2222: v_oth_pur_npe_qty, v_oth_purpose,
2223: v_manu_loose_qty, 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 2524: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,

2520: transaction_type, range_no, division_no, location_id,
2521: transaction_uom_code, transaction_date,
2522: primary_uom_code,
2523: REF_DOC_NO -- cbabu 25/07/02 for Bug#2480524
2524: ) VALUES (JAI_CMN_RG_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2525: v_manufactured_qty, v_manufactured_pack_qty,
2526: v_manu_loose_qty, v_bal_packed,
2527: v_bal_loose, v_trans_qty,
2528: v_t_qty, pr_new.last_update_date,