APPS.JAI_CMN_RG_MASTER_ORG_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 243: from JAI_CMN_INVENTORY_ORGS

239: p_location_id IN NUMBER) as
240:
241: Cursor master_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
242: Select ec_code
243: from JAI_CMN_INVENTORY_ORGS
244: Where organization_id = p_organization_id
245: And location_id = nvl(p_location_id,0);
246: v_ec_code Varchar2(50);
247:

Line 256: From JAI_CMN_RG_23AC_I_TRXS a, JAI_CMN_INVENTORY_ORGS b

252: rg23_rec rg23_part_i_cur%ROWTYPE;
253:
254: Cursor rg23_part_i_register_id_cur(p_ec_code IN Varchar2) IS
255: Select register_id
256: From JAI_CMN_RG_23AC_I_TRXS a, JAI_CMN_INVENTORY_ORGS b
257: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
258: And ( a.master_flag IS NULL OR a.master_flag = 'N') --rchandan for bug#4428980
259: And a.organization_id = b.organization_id
260: And a.location_id = b.location_id

Line 535: from JAI_CMN_INVENTORY_ORGS

531: p_location_id IN NUMBER) as
532:
533: Cursor master_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
534: Select ec_code
535: from JAI_CMN_INVENTORY_ORGS
536: Where organization_id = p_organization_id
537: And location_id = nvl(p_location_id,0);
538: v_ec_code Varchar2(50);
539:

Line 548: From JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_INVENTORY_ORGS b

544: rg23_rec rg23_part_ii_cur%ROWTYPE;
545:
546: Cursor rg23_part_ii_register_id_cur(p_ec_code IN Varchar2) IS
547: Select register_id
548: From JAI_CMN_RG_23AC_II_TRXS a, JAI_CMN_INVENTORY_ORGS b
549: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
550: And ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
551: And a.organization_id = b.organization_id
552: And a.location_id = b.location_id

Line 898: from JAI_CMN_INVENTORY_ORGS

894: p_location_id IN NUMBER) as
895:
896: Cursor master_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
897: Select ec_code
898: from JAI_CMN_INVENTORY_ORGS
899: Where organization_id = p_organization_id
900: And location_id = nvl(p_location_id,0);
901: v_ec_code Varchar2(50);
902:

Line 911: From JAI_CMN_RG_PLA_TRXS a, JAI_CMN_INVENTORY_ORGS b

907: pla_rec pla_cur%ROWTYPE;
908:
909: Cursor pla_register_id_cur(p_ec_code IN Varchar2) IS
910: Select register_id
911: From JAI_CMN_RG_PLA_TRXS a, JAI_CMN_INVENTORY_ORGS b
912: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
913: And ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
914: And a.organization_id = b.organization_id
915: And a.location_id = b.location_id

Line 1256: FROM JAI_CMN_INVENTORY_ORGS

1252: AS
1253:
1254: CURSOR master_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1255: SELECT ec_code
1256: FROM JAI_CMN_INVENTORY_ORGS
1257: WHERE organization_id = p_organization_id
1258: AND location_id = nvl(p_location_id,0);
1259:
1260: CURSOR rgi_register_id_cur(p_ec_code IN VARCHAR2) IS

Line 1262: FROM JAI_CMN_RG_I_TRXS a, JAI_CMN_INVENTORY_ORGS b

1258: AND location_id = nvl(p_location_id,0);
1259:
1260: CURSOR rgi_register_id_cur(p_ec_code IN VARCHAR2) IS
1261: SELECT register_id
1262: FROM JAI_CMN_RG_I_TRXS a, JAI_CMN_INVENTORY_ORGS b
1263: WHERE ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
1264: AND ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
1265: AND a.organization_id = b.organization_id
1266: AND a.location_id = b.location_id