DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 22555: bom_inventory_components bic

22551:
22552: SELECT nvl(bic.required_for_revenue, 0)
22553: INTO l_is_rfr
22554: FROM oe_order_lines Line,
22555: bom_inventory_components bic
22556: WHERE Line.line_id = p_line_id
22557: AND Line.open_flag = 'N'
22558: AND bic.component_sequence_id = Line.component_sequence_id
22559: AND bic.component_item_id = Line.inventory_item_id;

Line 22569: bom_inventory_components bic

22565:
22566: SELECT count(1)
22567: INTO l_open_rfr_lines
22568: FROM oe_order_lines Line,
22569: bom_inventory_components bic
22570: WHERE Line.line_id <> p_line_id
22571: AND Line.top_model_line_id = p_top_model_line_id
22572: AND Line.link_to_line_id = p_link_to_line_id
22573: AND Line.open_flag = 'Y'