DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 24439: bom_inventory_components bic

24435:
24436: SELECT nvl(bic.required_for_revenue, 0)
24437: INTO l_is_rfr
24438: FROM oe_order_lines Line,
24439: bom_inventory_components bic
24440: WHERE Line.line_id = p_line_id
24441: AND Line.open_flag = 'N'
24442: AND bic.component_sequence_id = Line.component_sequence_id
24443: AND bic.component_item_id = Line.inventory_item_id;

Line 24453: bom_inventory_components bic

24449:
24450: SELECT count(1)
24451: INTO l_open_rfr_lines
24452: FROM oe_order_lines Line,
24453: bom_inventory_components bic
24454: WHERE Line.line_id <> p_line_id
24455: AND Line.top_model_line_id = p_top_model_line_id
24456: AND Line.link_to_line_id = p_link_to_line_id
24457: AND Line.open_flag = 'Y'