APPS.JAI_CMN_RG_MASTER_ORG_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 235: from JAI_CMN_INVENTORY_ORGS

231: p_location_id IN NUMBER) as
232:
233: Cursor master_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
234: Select ec_code
235: from JAI_CMN_INVENTORY_ORGS
236: Where organization_id = p_organization_id
237: And location_id = nvl(p_location_id,0);
238: v_ec_code Varchar2(50);
239:

Line 248: From JAI_CMN_RG_23AC_I_TRXS a, JAI_CMN_INVENTORY_ORGS b

244: rg23_rec rg23_part_i_cur%ROWTYPE;
245:
246: Cursor rg23_part_i_register_id_cur(p_ec_code IN Varchar2) IS
247: Select register_id
248: From JAI_CMN_RG_23AC_I_TRXS a, JAI_CMN_INVENTORY_ORGS b
249: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
250: And ( a.master_flag IS NULL OR a.master_flag = 'N') --rchandan for bug#4428980
251: And a.organization_id = b.organization_id
252: And a.location_id = b.location_id

Line 512: from JAI_CMN_INVENTORY_ORGS

508: p_location_id IN NUMBER) as
509:
510: Cursor master_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
511: Select ec_code
512: from JAI_CMN_INVENTORY_ORGS
513: Where organization_id = p_organization_id
514: And location_id = nvl(p_location_id,0);
515: v_ec_code Varchar2(50);
516:

Line 525: From JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_INVENTORY_ORGS b

521: rg23_rec rg23_part_ii_cur%ROWTYPE;
522:
523: Cursor rg23_part_ii_register_id_cur(p_ec_code IN Varchar2) IS
524: Select register_id
525: From JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_INVENTORY_ORGS b
526: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
527: And ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
528: And a.organization_id = b.organization_id
529: And a.location_id = b.location_id

Line 867: from JAI_CMN_INVENTORY_ORGS

863: p_location_id IN NUMBER) as
864:
865: Cursor master_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
866: Select ec_code
867: from JAI_CMN_INVENTORY_ORGS
868: Where organization_id = p_organization_id
869: And location_id = nvl(p_location_id,0);
870: v_ec_code Varchar2(50);
871:

Line 880: From JAI_CMN_RG_PLA_TRXS a, JAI_CMN_INVENTORY_ORGS b

876: pla_rec pla_cur%ROWTYPE;
877:
878: Cursor pla_register_id_cur(p_ec_code IN Varchar2) IS
879: Select register_id
880: From JAI_CMN_RG_PLA_TRXS a, JAI_CMN_INVENTORY_ORGS b
881: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
882: And ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
883: And a.organization_id = b.organization_id
884: And a.location_id = b.location_id

Line 1225: FROM JAI_CMN_INVENTORY_ORGS

1221: AS
1222:
1223: CURSOR master_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1224: SELECT ec_code
1225: FROM JAI_CMN_INVENTORY_ORGS
1226: WHERE organization_id = p_organization_id
1227: AND location_id = nvl(p_location_id,0);
1228:
1229: CURSOR rgi_register_id_cur(p_ec_code IN VARCHAR2) IS

Line 1231: FROM JAI_CMN_RG_I_TRXS a, JAI_CMN_INVENTORY_ORGS b

1227: AND location_id = nvl(p_location_id,0);
1228:
1229: CURSOR rgi_register_id_cur(p_ec_code IN VARCHAR2) IS
1230: SELECT register_id
1231: FROM JAI_CMN_RG_I_TRXS a, JAI_CMN_INVENTORY_ORGS b
1232: WHERE ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
1233: AND ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
1234: AND a.organization_id = b.organization_id
1235: AND a.location_id = b.location_id