DBA Data[Home] [Help]

APPS.CSP_PLAN_DETAILS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 128: from mtl_system_items msi,

124: order by misl.rank;
125:
126: cursor c_nb_int_ext(p_organization_id number, p_supplied_item_id number) is
127: select decode(nvl(msi.source_type,mp.source_type),1,'INTERNAL','EXTERNAL')
128: from mtl_system_items msi,
129: mtl_parameters mp
130: where mp.organization_id = msi.organization_id
131: and msi.organization_id = p_organization_id
132: and msi.inventory_item_id = p_supplied_item_id;

Line 522: mtl_system_items_b msib,

518: ))
519: from MRP_ITEM_SOURCING_LEVELS_V misl,
520: csp_planning_parameters cpp,
521: mtl_interorg_ship_methods mism,
522: mtl_system_items_b msib,
523: hr_organization_information hoi
524: where msib.inventory_item_id = cpd.inventory_item_id
525: and msib.organization_id = decode(misl.source_type, 1, misl.source_organization_id, 3, hoi.organization_id)
526: and mism.to_organization_id = misl.organization_id

Line 549: from mtl_system_items_b msib

545: nvl(msib.postprocessing_lead_time,0),0,null,
546: nvl(msib.preprocessing_lead_time, 0) +
547: nvl(msib.full_lead_time, 0) +
548: nvl(msib.postprocessing_lead_time,0))
549: from mtl_system_items_b msib
550: where inventory_item_id = cpd.inventory_item_id
551: and organization_id = cpd.organization_id) NewBuy_Lead_Time,
552: fnd_global.user_id,
553: sysdate,

Line 2751: from mtl_system_items_b msib,

2747: cursor c_newbuy(p_inventory_item_id number) is
2748: select nvl(msib.source_organization_id,mp.source_organization_id),
2749: cpr.newbuy_edq,
2750: null
2751: from mtl_system_items_b msib,
2752: mtl_parameters mp,
2753: csp_plan_reorders cpr
2754: where msib.organization_id = l_organization_id
2755: and msib.inventory_item_id = p_inventory_item_id

Line 3164: from mtl_system_items_b msib,

3160: sysdate,
3161: fnd_global.user_id,
3162: sysdate,
3163: fnd_global.login_id
3164: from mtl_system_items_b msib,
3165: csp_plan_reorders cpr
3166: where msib.organization_id = l_organization_id
3167: and msib.inventory_item_id = nvl(l_inventory_item_id,msib.inventory_item_id)
3168: and cpr.organization_id(+) = msib.organization_id