DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on MSC_PHUB_DATES_MV

Line 1179: msc_phub_dates_mv d,

1175: fnd_global.conc_program_id, fnd_global.conc_login_id,
1176: fnd_global.prog_appl_id, fnd_global.conc_request_id
1177: from
1178: msc_bis_inv_detail mbid,
1179: msc_phub_dates_mv d,
1180: msc_apcc_item_d i
1181: where trunc(mbid.detail_date)=d.calendar_date
1182: and mbid.plan_id=p_plan_id
1183: and mbid.plan_id=i.plan_id

Line 1256: msc_phub_dates_mv d,

1252: fnd_global.conc_program_id, fnd_global.conc_login_id,
1253: fnd_global.prog_appl_id, fnd_global.conc_request_id
1254: from
1255: msc_whse_requirements mwr,
1256: msc_phub_dates_mv d,
1257: msc_apcc_item_d i
1258: where trunc(mwr.stock_date)=d.calendar_date
1259: and mwr.plan_id=p_plan_id
1260: and mwr.plan_id=i.plan_id

Line 1313: msc_phub_dates_mv d,

1309: fnd_global.conc_program_id, fnd_global.conc_login_id,
1310: fnd_global.prog_appl_id, fnd_global.conc_request_id
1311: from
1312: msc_demands_f f,
1313: msc_phub_dates_mv d,
1314: msc_apcc_item_d i
1315: where trunc(f.order_date)=d.calendar_date
1316: and f.plan_run_id=p_plan_run_id
1317: and f.aggr_type=0