DBA Data[Home] [Help]

APPS.MRP_SCATP_PUB dependencies on BOM_BILL_OF_MATERIALS

Line 149: bom_bill_of_materials bom,

145: FROM mtl_system_items msi,
146: mtl_parameters mp,
147: wip_parameters wp,
148: bom_explosions be,
149: bom_bill_of_materials bom,
150: mtl_demand_interface mdi
151: WHERE mdi.atp_group_id = l_atp_group_id
152: AND bom.assembly_item_id = mdi.inventory_item_id
153: AND bom.organization_id = mdi.organization_id

Line 408: FROM mtl_system_items msi, bom_bill_of_materials bbm

404: BEGIN
405:
406: SELECT NVL(msi.wip_supply_type,1)
407: INTO l_wip_supply_type
408: FROM mtl_system_items msi, bom_bill_of_materials bbm
409: WHERE bbm.bill_sequence_id = p_top_bill_seq_id
410: AND msi.organization_id = bbm.organization_id
411: AND msi.inventory_item_id = p_comp_id;
412: