DBA Data[Home] [Help]

APPS.MSC_ATP_CTO dependencies on STANDARD

Line 629: AND msi.bom_item_type = 4 -- chose always standard comp as option class will be passed by OM

625: AND msi.inventory_item_id = mbc.inventory_item_id
626: AND msi.organization_Id = mbc.organization_id
627: AND msi.plan_id = mbc.plan_id
628: AND msi.sr_instance_id = mbc.sr_instance_id
629: AND msi.bom_item_type = 4 -- chose always standard comp as option class will be passed by OM
630: AND (msi.atp_flag <> 'N' or msi.atp_components_flag <> 'N')
631: --4137608
632: -- effective date should be greater than or equal to greatest of PTF date, sysdate and request date
633: -- disable date should be less than or equal to greatest of PTF date, sysdate and request date