DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on BOM_COMPONENTS_B

Line 347: FROM bom_components_b

343: p_bill_sequence_id NUMBER,
344: p_component_item_id NUMBER
345: ) IS
346: SELECT component_sequence_id
347: FROM bom_components_b
348: WHERE
349: bill_sequence_id = p_bill_sequence_id AND
350: component_item_id = p_component_item_id AND
351: change_notice = p_eco_name;

Line 2069: FROM bom_components_b

2065: AND organization_id = l_organization_id
2066: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2067:
2068: SELECT component_sequence_id INTO l_component_sequence_id
2069: FROM bom_components_b
2070: WHERE bill_sequence_id = l_bill_sequence_id
2071: AND component_item_id = l_component_item_id
2072: AND change_notice = p_eco_name;
2073: