APPS.MSC_ATP_CTO dependencies on MSC_SYSTEM_ITEMS

Line 614: FROM MSC_SYSTEM_ITEMS MSI,

610: x_mand_comp_info_rec.component_yield_factor, --4570421
611: x_mand_comp_info_rec.usage_qty, --4775920
612: x_mand_comp_info_rec.organization_type --4775920
613:
614: FROM MSC_SYSTEM_ITEMS MSI,
615: MSC_BOM_COMPONENTS MBC
616: WHERE Mbc.plan_id = p_plan_id
617: AND mbc.sr_instance_id = p_instance_id
618: AND mbc.bill_sequence_id = l_bill_seq_id

Line 1106: from msc_system_items

1102: --- this query can't be put with the query below there are no common linking columns
1103: /* BEGIN
1104: select fixed_lead_time, variable_lead_time
1105: into l_fixed_lt, l_variable_lt
1106: from msc_system_items
1107: where plan_id = p_plan_id
1108: and sr_instance_id = p_instance_id
1109: and sr_inventory_item_id = p_inventory_item_id
1110: and organization_id = p_organization_id;

Line 1204: msc_system_items msi,

1200: FROM msc_cto_bom mcb,
1201: msc_calendar_dates c1,
1202: msc_calendar_dates c2,
1203: msc_trading_partners tp,
1204: msc_system_items msi,
1205: msc_bom_components mbc,
1206: MSC_OPERATION_COMPONENTS MOC
1207: WHERE mcb.session_id = p_session_id
1208: AND mcb.sr_instance_id = MSC_ATP_PVT.G_INSTANCE_ID -- this is the instance id of the calling module

Line 1314: from msc_system_items msi

1310: END IF;
1311: --first get base model's flags
1312: Select atp_flag, atp_components_flag, sr_inventory_item_id
1313: into l_atp_flag, l_atp_comp_flag, x_model_sr_inv_id
1314: from msc_system_items msi
1315: where msi.inventory_item_id = p_base_model_id
1316: and msi.sr_instance_id = p_instance_id
1317: and msi.plan_id = p_plan_id
1318: and msi.organization_id = p_organization_id;