DBA Data[Home] [Help]

APPS.MSC_ATP_CTO dependencies on MSC_BOM_COMPONENTS

Line 615: MSC_BOM_COMPONENTS MBC

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

Line 1205: msc_bom_components mbc,

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

Line 1365: from msc_bom_components mbc

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