APPS.OPI_EDW_JOB_DETAIL_F_SZ dependencies on MTL_MATERIAL_TRANSACTIONS

Line 193: MTL_MATERIAL_TRANSACTIONS MMT;

189: SELECT
190: -- ACT_MTL_INP_VAL, PLN_MTL_INP_VAl, ACT_BPR_VAL, PLN_BPR_VAl, ACT_OUT_VAL, AVG_ACT_UNIT_CMPL_CST (used twice: STD_VAL_B, PLN_OUT_VAL_B), ACT_SCR_VAL
191: avg(nvl(vsize(MMT.PRIMARY_QUANTITY), 0))
192: FROM
193: MTL_MATERIAL_TRANSACTIONS MMT;
194:
195: CURSOR c_8 IS
196: SELECT
197: avg(nvl(vsize((NVL(DI.DATE_COMPLETED,DI.date_closed) - DI.SCHEDULED_START_DATE)), 0)) -- ACT_JOB_TIME AND PLN_JOB_TIME