APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on SY_ORGN_MST

Line 41: l_prev_co_code sy_orgn_mst.co_code%TYPE;

37: order by gpm.co_code,c.period_start_date desc;
38: -- Row Type Variables
39: cldr_rec check_cldr_for_perd_bal%ROWTYPE;
40: -- Local Variables
41: l_prev_co_code sy_orgn_mst.co_code%TYPE;
42: BEGIN
43: OPEN check_cldr_for_perd_bal;
44: LOOP
45: FETCH check_cldr_for_perd_bal INTO cldr_rec;

Line 128: SY_ORGN_MST org,

124: FROM (SELECT whse_code,item_id,sum(LOCT_ONHAND) loct_onhand
125: from IC_LOCT_INV
126: group by whse_code,item_id) loct,
127: IC_WHSE_MST whs,
128: SY_ORGN_MST org,
129: IC_ITEM_MST iim
130: WHERE org.co_code = cldr_rec.co_code
131: AND loct.item_id = iim.item_id
132: AND loct.whse_code = whs.whse_code

Line 309: SY_ORGN_MST org,

305: MINUS
306: SELECT WHSE_CODE,ITEM_ID
307: FROM PMI_ONHAND_SALE_SUM_TEMP) prd_sum,
308: IC_WHSE_MST whs,
309: SY_ORGN_MST org,
310: IC_ITEM_MST iim
311: WHERE co_code = cldr_rec.co_code
312: AND prd_sum.item_id = iim.item_id
313: AND prd_sum.whse_code = whs.whse_code