DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on BOM_COMPONENTS_B

Line 352: FROM bom_components_b

348: p_bill_sequence_id NUMBER,
349: p_component_item_id NUMBER
350: ) IS
351: SELECT component_sequence_id
352: FROM bom_components_b
353: WHERE
354: bill_sequence_id = p_bill_sequence_id AND
355: component_item_id = p_component_item_id AND
356: change_notice = p_eco_name;

Line 2712: FROM bom_components_b

2708: AND organization_id = l_organization_id
2709: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2710:
2711: SELECT component_sequence_id INTO l_component_sequence_id
2712: FROM bom_components_b
2713: WHERE bill_sequence_id = l_bill_sequence_id
2714: AND component_item_id = l_component_item_id
2715: AND change_notice = p_eco_name;
2716: