APPS.OE_INVOICE_PUB dependencies on BOM_INVENTORY_COMPONENTS

Line 1758: bom_inventory_components bic

1754: IS
1755: Cursor rfr_child is
1756: SELECT line_id
1757: FROM oe_order_lines Line,
1758: bom_inventory_components bic
1759: WHERE Line.link_to_line_id = p_line_id
1760: AND Line.open_flag || '' = 'Y'
1761: AND bic.component_sequence_id = Line.component_sequence_id
1762: AND bic.component_item_id = Line.inventory_item_id

Line 1801: bom_inventory_components bic

1797: -- lines
1798: Cursor rfr_sibling is
1799: SELECT line_id
1800: FROM oe_order_lines Line,
1801: bom_inventory_components bic
1802: WHERE Line.link_to_line_id = p_link_to_line_id
1803: AND Line.inventory_item_id <> p_line_inventory_item_id
1804: AND Line.open_flag || '' = 'Y'
1805: AND bic.component_sequence_id = Line.component_sequence_id

Line 1845: bom_inventory_components bic

1841: BEGIN
1842: SELECT 'Y'
1843: INTO l_rfr
1844: FROM oe_order_lines Line,
1845: bom_inventory_components bic
1846: WHERE Line.line_id = p_line_id
1847: AND Line.open_flag || '' = 'Y'
1848: AND bic.component_sequence_id = Line.component_sequence_id
1849: AND bic.component_item_id = Line.inventory_item_id