DBA Data[Home] [Help]

APPS.MRP_SCATP_PUB dependencies on MTL_SYSTEM_ITEMS

Line 145: FROM mtl_system_items msi,

141: mdi.atp_calendar_organization_id,
142: 1,
143: be.primary_uom_code,
144: mdi.supply_header_id
145: FROM mtl_system_items msi,
146: mtl_parameters mp,
147: wip_parameters wp,
148: bom_explosions be,
149: bom_bill_of_materials bom,

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: