DBA Data[Home] [Help]

APPS.CZ_OM_ATP_CALLBACK dependencies on BOM_BILL_OF_MATERIALS

Line 302: FROM bom_bill_of_materials

298: AND plan_level > 0
299: AND extended_quantity > 0
300: AND TOP_BILL_SEQUENCE_ID =
301: (SELECT bill_sequence_id
302: FROM bom_bill_of_materials
303: WHERE assembly_item_id = g_atp_rec.inventory_item_id(i)
304: AND organization_id = p_organization_id
305: AND ALTERNATE_BOM_DESIGNATOR IS NULL)
306: AND EFFECTIVITY_DATE <= SYSDATE AND DISABLE_DATE > SYSDATE; -- AND check_atp = 1?