DBA Data[Home] [Help]

APPS.PMI_BUILD_PROD_SUM dependencies on IC_WHSE_MST

Line 131: IC_WHSE_MST whs,

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,
131: IC_WHSE_MST whs,
132: SY_ORGN_MST org,
133: IC_ITEM_MST iim
134: WHERE org.co_code = cldr_rec.co_code
135: AND prod_tr.item_id = iim.item_id