DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on MSC_BIS_INV_DETAIL

Line 919: from msc_bis_inv_detail mbid, msc_hub_query d

915: mbid.pab pab_qty,
916: rank() over (partition by mbid.plan_id,
917: mbid.sr_instance_id, mbid.organization_id, mbid.inventory_item_id,
918: d.date2 order by mbid.detail_date desc, nvl(mbid.period_type,0) desc) rn
919: from msc_bis_inv_detail mbid, msc_hub_query d
920: where mbid.plan_id=p_plan_id
921: and l_plan_type=6
922: and d.query_id=l_qid_last_date1
923: and mbid.detail_date <= d.date2

Line 1178: msc_bis_inv_detail mbid,

1174: sysdate, fnd_global.user_id, fnd_global.login_id,
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