DBA Data[Home] [Help]

APPS.MSC_ATP_UTILS dependencies on MTL_SYSTEM_ITEMS

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

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

Line 978: MTL_SYSTEM_ITEMS msi,

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

Line 2762: from mtl_system_items msi

2758: ---bug 4078703: populate ATP lead time
2759: CEIL(decode(mast.order_line_id, mast.ato_model_line_id,
2760: decode(bom_item_type, 1,
2761: (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))
2762: from mtl_system_items msi
2763: where msi.organization_id = nvl(mast.source_organization_id, mast.validation_org)
2764: and msi.inventory_item_id = mast.inventory_item_id)
2765: where mast.session_id = p_session_id
2766: --bug 3378648

Line 3099: from mtl_system_items msi

3095: msi.bom_item_type,
3096: msi.pick_components_flag,
3097: msi.fixed_lead_time,
3098: msi.VARIABLE_LEAD_TIME
3099: from mtl_system_items msi
3100: where msi.organization_id = nvl(mast.source_organization_id, mast.validation_org)
3101: and msi.inventory_item_id = mast.inventory_item_id)
3102: where mast.session_id = p_session_id
3103: --bug 3378648: only update request data