DBA Data[Home] [Help]

APPS.MSD_DEM_SR_UTIL dependencies on OE_ORDER_LINES_ALL

Line 391: from oe_order_lines_all l

387: p_ato_line_id IN NUMBER) IS
388: select count(1)
389: from mtl_system_items itm
390: where inventory_item_id = (select inventory_item_id
391: from oe_order_lines_all l
392: where l.item_type_code = 'CONFIG'
393: and l.header_id = p_header_id
394: and l.org_id = p_org_id
395: and l.ato_line_id = p_ato_line_id )

Line 674: oe_order_lines_all

670: item_type_code,
671: link_to_line_id,
672: ato_line_id
673: FROM
674: oe_order_lines_all
675: WHERE
676: line_id = x_line_id;
677:
678: BEGIN

Line 723: FROM oe_order_lines_all

719: BEGIN
720:
721: SELECT inventory_item_id
722: INTO x_base_model_id
723: FROM oe_order_lines_all
724: WHERE line_id = p_top_model_line_id;
725:
726: RETURN x_base_model_id;
727:

Line 766: FROM oe_order_lines_all

762:
763: CURSOR C_PARENT_ITEM
764: IS
765: SELECT component_sequence_id
766: FROM oe_order_lines_all
767: WHERE line_id = p_parent_line_id;
768:
769: /* The parent of optional item has to be either consume and drive or none with optional = YES */
770: CURSOR C_IS_PARENT_OPTIONAL