APPS.PMI_BUILD_PROD_SUM dependencies on IC_TRAN_CMP

Line 126: DECODE(line_type,-1,trans_qty,0) usage_qty FROM IC_TRAN_CMP

122: AND doc_type ='PROD'
123: AND completed_ind = 1 and delete_mark = 0
124: UNION ALL
125: SELECT ORGN_CODE,WHSE_CODE,ITEM_ID,decode(line_type,1,trans_qty,0) yield_qty,
126: DECODE(line_type,-1,trans_qty,0) usage_qty FROM IC_TRAN_CMP
127: WHERE trunc(trans_date) between cldr_rec.period_start_date AND
128: cldr_rec.period_end_date
129: AND doc_type = 'PROD')
130: group by orgn_code,whse_code,item_id) prod_tr,

Line 170: from IC_TRAN_CMP

166: WHERE doc_type = 'PROD' AND (l_last_run_date IS NULL OR
167: (l_last_run_date IS NOT NULL AND last_update_date >= l_last_run_date))
168: UNION ALL
169: (Select (min(trans_date)) trans_date
170: from IC_TRAN_CMP
171: WHERE DOC_TYPE = 'PROD' AND (l_last_run_date IS NULL OR
172: (l_last_run_date IS NOT NULL AND last_update_date >= l_last_run_date))));
173: rows_exists number := null;
174: BEGIN