APPS.MSC_ATP_UTILS dependencies on MTL_SYSTEM_ITEMS

Line 209: -- bug 1878093, pass atp_flag from mtl_system_items to destination

205:
206: -- cchen: rewrite this sql_stmt. based on the mode we either have status 1
207: -- or 2 in the where clause
208:
209: -- bug 1878093, pass atp_flag from mtl_system_items to destination
210: -- for use in case item has not been collected as yet.
211:
212: --pegging enhancement: If on same database then use bulk collect
213: --- can't use bulk collect in case of distributed set up becauase its not supported.

Line 980: MTL_SYSTEM_ITEMS msi,

976: x_atp_rec.message
977: FROM
978: mrp_ap_apps_instances mai,
979: ORG_ORGANIZATION_DEFINITIONS ood,
980: MTL_SYSTEM_ITEMS msi,
981: MTL_DEMAND_INTERFACE mdi
982: WHERE mdi.atp_group_id = p_group_id
983: AND ((mdi.demand_type = 1
984: AND EXISTS (SELECT 'ATO Model exists'

Line 2764: from mtl_system_items msi

2760: ---bug 4078703: populate ATP lead time
2761: CEIL(decode(mast.order_line_id, mast.ato_model_line_id,
2762: decode(bom_item_type, 1,
2763: (NVL(msi.fixed_lead_time, 0) + (NVL(msi.VARIABLE_LEAD_TIME, 0) * mast.quantity_ordered)) * (1 + MSC_ATP_PVT.G_MSO_LEAD_TIME_FACTOR), 0), null))
2764: from mtl_system_items msi
2765: where msi.organization_id = nvl(mast.source_organization_id, mast.validation_org)
2766: and msi.inventory_item_id = mast.inventory_item_id)
2767: where mast.session_id = p_session_id
2768: --bug 3378648

Line 3148: from mtl_system_items msi

3144: msi.bom_item_type,
3145: msi.pick_components_flag,
3146: msi.fixed_lead_time,
3147: msi.VARIABLE_LEAD_TIME
3148: from mtl_system_items msi
3149: where msi.organization_id = nvl(mast.source_organization_id, mast.validation_org)
3150: and msi.inventory_item_id = mast.inventory_item_id)
3151: where mast.session_id = p_session_id
3152: --bug 3378648: only update request data