DBA Data[Home] [Help]

APPS.MSC_ATP_CTO dependencies on MSC_BOM_COMPONENTS

Line 612: MSC_BOM_COMPONENTS MBC

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
616: AND mbc.using_assembly_id = l_inventory_item_id

Line 1202: msc_bom_components mbc,

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
1206: AND mcb.PARENT_LINE_ID = p_line_id

Line 1362: from msc_bom_components mbc

1358:
1359: ---now select the bom level atp flag to see if we need need to do capacity check
1360: SELECT NVL(mbc.atp_flag, 2)
1361: INTO x_check_model_capacity_flag
1362: from msc_bom_components mbc
1363: where mbc.BILL_SEQUENCE_ID = l_bill_seq_id
1364: and mbc.PLAN_ID = p_plan_id
1365: and mbc.SR_INSTANCE_ID = p_instance_id
1366: and mbc.ORGANIZATION_ID = p_organization_id