APPS.OE_INVOICE_PUB dependencies on BOM_INVENTORY_COMPONENTS

Line 1975: bom_inventory_components bic

1971: IS
1972: Cursor rfr_child is
1973: SELECT line_id
1974: FROM oe_order_lines Line,
1975: bom_inventory_components bic
1976: WHERE Line.link_to_line_id = p_line_id
1977: AND Line.open_flag || '' = 'Y'
1978: AND bic.component_sequence_id = Line.component_sequence_id
1979: AND bic.component_item_id = Line.inventory_item_id

Line 2018: bom_inventory_components bic

2014: -- lines
2015: Cursor rfr_sibling is
2016: SELECT line_id
2017: FROM oe_order_lines Line,
2018: bom_inventory_components bic
2019: WHERE Line.link_to_line_id = p_link_to_line_id
2020: AND Line.inventory_item_id <> p_line_inventory_item_id
2021: AND Line.open_flag || '' = 'Y'
2022: AND bic.component_sequence_id = Line.component_sequence_id

Line 2062: bom_inventory_components bic

2058: BEGIN
2059: SELECT 'Y'
2060: INTO l_rfr
2061: FROM oe_order_lines Line,
2062: bom_inventory_components bic
2063: WHERE Line.line_id = p_line_id
2064: AND Line.open_flag || '' = 'Y'
2065: AND bic.component_sequence_id = Line.component_sequence_id
2066: AND bic.component_item_id = Line.inventory_item_id