DBA Data[Home] [Help]

APPS.MRP_SCATP_PUB dependencies on BOM_INVENTORY_COMPONENTS

Line 338: FROM BOM_INVENTORY_COMPONENTS

334:
335: BEGIN
336: SELECT '1'
337: INTO l_required
338: FROM BOM_INVENTORY_COMPONENTS
339: WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id
340: AND NVL(WIP_SUPPLY_TYPE,
341: MRP_SCATP_PUB.mtl_wip_supply_type(
342: p_top_bill_seq_id,

Line 369: FROM BOM_INVENTORY_COMPONENTS BIC,

365: -- so we end up triple count the component demand for the option.
366: -- so we need to make sure all the parents are not model/oc.
367: SELECT '1'
368: INTO l_required
369: FROM BOM_INVENTORY_COMPONENTS BIC,
370: BOM_EXPLOSIONS BE
371: WHERE BE.TOP_BILL_SEQUENCE_ID = p_top_bill_seq_id
372: AND BE.COMPONENT_CODE = l_component_code
373: AND BE.PLAN_LEVEL = i