DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_BOMS

Line 2972: MSC_BOMS MB,

2968: FROM (SELECT MBC.inventory_item_id,
2969: ABS(NVL(MBC.usage_quantity,1) * p_assembly_qty/
2970: NVL(MB.assembly_quantity,1)) quantity
2971: FROM MSC_SYSTEM_ITEMS I,
2972: MSC_BOMS MB,
2973: MSC_BOM_COMPONENTS MBC,
2974: MSC_CALENDAR_DATES C,
2975: MSC_TRADING_PARTNERS TP
2976: WHERE I.plan_id = p_plan_id and