APPS.MSC_ATP_CTO dependencies on MSC_SYSTEM_ITEMS

Line 611: FROM MSC_SYSTEM_ITEMS MSI,

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

Line 1103: from msc_system_items

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

Line 1201: msc_system_items msi,

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

Line 1311: from msc_system_items msi

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