APPS.MSC_ITEM_PKG dependencies on MSC_BIS_INV_DETAIL

Line 260: from msc_bis_inv_detail mbid, msc_plans mp

256: )
257: select unique l_qid_bis_week,
258: l_sysdate,1,l_sysdate,1,1,
259: trunc(mbid.detail_date)
260: from msc_bis_inv_detail mbid, msc_plans mp
261: where mbid.plan_id=p_plan_id
262: and mbid.plan_id=mp.plan_id
263: and (nvl(mbid.detail_level,0)=1 or mp.plan_type=6)
264: and nvl(mbid.period_type,0)=1;

Line 285: date3 -- bis week start date=msc_bis_inv_detail.detail_date

281: created_by,
282: last_update_login,
283: date1 , -- hub week start date
284: date2 , -- hub week end date
285: date3 -- bis week start date=msc_bis_inv_detail.detail_date
286: )
287: select unique l_qid_week_map,
288: l_sysdate,1,l_sysdate,1,1,
289: mfg.date1 hub_week_start_date,

Line 1247: and mp.plan_type<>6 --- msc_bis_inv_detail.pab column

1243: and pab.sr_instance_id = mtp.sr_instance_id(+)
1244: and pab.organization_id = mtp.sr_tp_id(+)
1245: and mtp.partner_type(+) = 3
1246: and pab.plan_id= mp.plan_id --- exclude sno plan since sno plan, pab is from msc
1247: and mp.plan_type<>6 --- msc_bis_inv_detail.pab column
1248:
1249: union all
1250: select
1251: ss.number1 plan_id,

Line 1463: from msc_bis_inv_detail mbid,

1459: nvl(mbid.PRODUCTION_COST,0) + nvl(mbid.mds_cost,0)+ nvl(mbid.purchasing_cost,0) +
1460: nvl(mbid.carrying_cost,0) + nvl(mbid.TRANSPORTATION_COST,0) total_cost,
1461: to_number(null) inv_build_target
1462: ----------------------------------------------------------------------------
1463: from msc_bis_inv_detail mbid,
1464: msc_hub_query vmi,
1465: msc_hub_query map,
1466: msc_trading_partners bis_mtp,
1467: msc_plans mp

Line 1497: ----- msc_bis_inv_detail.pab is not a cumulative value. It is calculated for each bucket independently

1493: nvl(bis_mtp.currency_code, l_owning_currency_code) currency_code,
1494: map.date2 order_date, --- hub week end date
1495: ----------------------------------------------------------------------------
1496: ----- inventory build target from sno is not cum value yet.
1497: ----- msc_bis_inv_detail.pab is not a cumulative value. It is calculated for each bucket independently
1498:
1499: last_value(mbid.pab ignore nulls) over (partition by mbid.plan_id, mbid.sr_instance_id,
1500: mbid.organization_id, mbid.inventory_item_id,
1501: mbid.ship_method

Line 1503: --- assume that msc_bis_inv_detail.pab is only

1499: last_value(mbid.pab ignore nulls) over (partition by mbid.plan_id, mbid.sr_instance_id,
1500: mbid.organization_id, mbid.inventory_item_id,
1501: mbid.ship_method
1502: order by map.date2) pab_qty,
1503: --- assume that msc_bis_inv_detail.pab is only
1504: --- populated in sno plan
1505: last_value(mbid.pab ignore nulls) over (partition by mbid.plan_id, mbid.sr_instance_id,
1506: mbid.organization_id, mbid.inventory_item_id,
1507: mbid.ship_method

Line 1528: ----- msc_bis_inv_detail.pab is not a cumulative value. It is calculated for each bucket independently

1524: mbid.carrying_cost carrying_cost,
1525: nvl(mbid.PRODUCTION_COST,0) + nvl(mbid.mds_cost,0)+ nvl(mbid.purchasing_cost,0) +
1526: nvl(mbid.carrying_cost,0) + nvl(mbid.TRANSPORTATION_COST,0) total_cost,
1527: ----- inventory build target from sno is not cum value yet.
1528: ----- msc_bis_inv_detail.pab is not a cumulative value. It is calculated for each bucket independently
1529:
1530: last_value(mbid.pab ignore nulls) over (partition by mbid.plan_id, mbid.sr_instance_id,
1531: mbid.organization_id, mbid.inventory_item_id,
1532: mbid.ship_method

Line 1550: from msc_bis_inv_detail mbid1 where mbid1.plan_id=p_plan_id

1546: sum(nvl(mbid1.mds_cost,0) ) mds_cost,
1547: sum(nvl(mbid1.purchasing_cost,0) ) purchasing_cost,
1548: sum(nvl(mbid1.TRANSPORTATION_COST,0) ) TRANSPORTATION_COST,
1549: sum(nvl(mbid1.carrying_cost,0)) carrying_cost
1550: from msc_bis_inv_detail mbid1 where mbid1.plan_id=p_plan_id
1551: group by
1552: p_plan_id,
1553: mbid1.sr_instance_id,
1554: mbid1.organization_id,