APPS.EDW_MTL_INVENTORY_LOC_M_SZ dependencies on SY_ORGN_MST

Line 54: FROM SY_ORGN_MST

50: where last_update_date between p_from_date and p_to_date
51: -- Inventory Organization Parent Goup level
52: union all
53: SELECT COUNT(*) cnt
54: FROM SY_ORGN_MST
55: WHERE ORGN_CODE = CO_CODE
56: -- Inventory Organization Parent Goup level
57: union all
58: SELECT COUNT(*) cnt

Line 59: FROM SY_ORGN_MST

55: WHERE ORGN_CODE = CO_CODE
56: -- Inventory Organization Parent Goup level
57: union all
58: SELECT COUNT(*) cnt
59: FROM SY_ORGN_MST
60: -- Locator level non location controlled
61: UNION ALL
62: SELECT COUNT(*) cnt
63: FROM IC_LOCT_INV ILI,

Line 225: FROM SY_ORGN_MST;

221:
222: CURSOR c_8 IS
223: SELECT avg(nvl(vsize(ORGN_CODE),0)) ORGN_CODE,
224: avg(nvl(vsize(ORGN_NAME),0)) ORGN_NAME
225: FROM SY_ORGN_MST;
226:
227: BEGIN
228:
229: --dbms_output.put_line ('******************'||x_total||'******') ;