APPS.IBE_CCTBOM_PVT dependencies on BOM_EXPLOSIONS

Line 15: SELECT component_item_id,optional,bom_item_type FROM BOM_EXPLOSIONS

11: l_isModelBundle VARCHAR2(1);
12: l_isEmptyModelItem VARCHAR2(1); --gzhang 12/12/02, #2709735
13:
14: cursor l_option_class_csr IS
15: SELECT component_item_id,optional,bom_item_type FROM BOM_EXPLOSIONS
16: WHERE top_bill_sequence_id =
17: (SELECT bill_sequence_id FROM bom_structures_b
18: WHERE assembly_item_id = p_model_id
19: AND organization_id = p_organization_id

Line 54: FROM BOM_EXPLOSIONS

50: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Looking for items with component code like '||l_component_code);
51: END IF;
52:
53: SELECT count(component_item_id) into l_total_component_items
54: FROM BOM_EXPLOSIONS
55: WHERE top_bill_sequence_id =
56: (SELECT bill_sequence_id
57: FROM bom_structures_b
58: WHERE assembly_item_id = p_model_id

Line 73: FROM BOM_EXPLOSIONS

69: IBE_UTIL.DEBUG(G_PKG_NAME||'.Validate_Model_Bundle: Found '||l_total_component_items||' component item(s)');
70: END IF;
71: IF l_total_component_items = 1 THEN
72: SELECT component_item_id, optional into l_item_id,l_optional
73: FROM BOM_EXPLOSIONS
74: WHERE top_bill_sequence_id =
75: (SELECT bill_sequence_id
76: FROM bom_structures_b
77: WHERE assembly_item_id = p_model_id

Line 387: FROM BOM_EXPLOSIONS

383: BOM_ITEM_TYPE,
384: PRIMARY_UOM_CODE,
385: COMPONENT_QUANTITY,
386: COMPONENT_CODE
387: FROM BOM_EXPLOSIONS
388: WHERE top_bill_sequence_id =
389: (SELECT bill_sequence_id FROM bom_structures_b
390: WHERE assembly_item_id = p_model_id
391: AND organization_id = p_organization_id