APPS.PMI_BUILD_PROD_SUM dependencies on IC_TRAN_PND

Line 119: FROM IC_TRAN_PND

115: ,0 MISS_CONV_FACT_CNT
116: FROM (SELECT orgn_code,whse_code,item_id,sum(yield_qty) yield_qty,sum(usage_qty) usage_qty
117: FROM (SELECT ORGN_CODE,WHSE_CODE,ITEM_ID,decode(line_type,1,trans_qty,0) yield_qty,
118: DECODE(line_type,-1,trans_qty,0) usage_qty
119: FROM IC_TRAN_PND
120: WHERE trunc(trans_date) between cldr_rec.period_start_date AND
121: cldr_rec.period_end_date
122: AND doc_type ='PROD'
123: AND completed_ind = 1 and delete_mark = 0

Line 165: from IC_TRAN_PND

161: WHERE summary_table = 'PMI_PROD_SUM';
162: CURSOR cur_last_trans_eff_date IS
163: SELECT min(trans_date)
164: from (Select (min(trans_date)) trans_date
165: from IC_TRAN_PND
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