APPS.GR_MIGRATE_TO_12 dependencies on SY_ORGN_MST

Line 329: FROM sy_orgn_mst_b

325: /* ------------------ CURSORS ---------------------- */
326: /* Cursor used retrieve the master organizations that will track Regulatory data */
327: CURSOR c_get_master_orgs IS
328: SELECT organization_id
329: FROM sy_orgn_mst_b
330: WHERE master_organization_id IS NULL and
331: regulatory_org_ind = 'Y'and
332: organization_id is not null; --in case the org is not migrated then this indicates that
333:

Line 337: FROM sy_orgn_mst_b

333:
334: /* Cursor used retrieve the child organizations that will track Regulatory data */
335: CURSOR c_get_child_orgs IS
336: SELECT organization_id
337: FROM sy_orgn_mst_b
338: WHERE master_organization_id IS NOT NULL and
339: regulatory_org_ind = 'Y' and
340: organization_id is not null;
341:

Line 1266: l_owner_org sy_orgn_mst.orgn_code%TYPE;

1262: l_exists_count NUMBER := 0;
1263: l_item_code VARCHAR2(32);
1264: l_uom_type sy_uoms_typ.um_type%TYPE;
1265: l_uom VARCHAR2(4);
1266: l_owner_org sy_orgn_mst.orgn_code%TYPE;
1267: l_owner_org_id sy_orgn_mst.organization_id%TYPE;
1268: l_inventory_item_id NUMBER;
1269: l_text VARCHAR2(80);
1270: l_line_no NUMBER;

Line 1267: l_owner_org_id sy_orgn_mst.organization_id%TYPE;

1263: l_item_code VARCHAR2(32);
1264: l_uom_type sy_uoms_typ.um_type%TYPE;
1265: l_uom VARCHAR2(4);
1266: l_owner_org sy_orgn_mst.orgn_code%TYPE;
1267: l_owner_org_id sy_orgn_mst.organization_id%TYPE;
1268: l_inventory_item_id NUMBER;
1269: l_text VARCHAR2(80);
1270: l_line_no NUMBER;
1271: l_formula_id NUMBER;

Line 1334: FROM sy_orgn_mst

1330:
1331: /* Cursor used to retrieve organization_id */
1332: CURSOR c_get_organization_id (v_org_code VARCHAR2) IS
1333: SELECT organization_id
1334: FROM sy_orgn_mst
1335: WHERE orgn_code = v_org_code;
1336:
1337: /* Cursor used to retrieve items primary_uom */
1338: CURSOR c_get_primary_uom (v_organization_id NUMBER, v_inventory_item_id NUMBER) IS

Line 2033: FROM sy_orgn_mst_b

2029:
2030: /* Cursor used retrieve organization id */
2031: CURSOR c_get_org_id (v_orgn_code VARCHAR2) IS
2032: SELECT organization_id
2033: FROM sy_orgn_mst_b
2034: WHERE orgn_code = v_orgn_code;
2035:
2036: /* Cursor used retrieve the records that don't have an organization id */
2037: CURSOR c_get_disp_rec IS