DBA Data[Home] [Help]

APPS.OE_BULK_CONFIG_UTIL dependencies on OE_ORDER_LINES_S

Line 1896: oe_order_lines_s.nextval Line_id,

1892: BOM_ITEM_TYPE,
1893: LOCK_CONTROL,
1894: REPLENISH_TO_ORDER_FLAG )
1895: SELECT
1896: oe_order_lines_s.nextval Line_id,
1897: l_line_rec.line_id(I) top_model_line_id,
1898: decode(z.config_item_id, z.ato_config_item_id, oe_order_lines_s.currval,NULL)
1899: ato_line_id,
1900: decode(z.config_item_id, z.ato_config_item_id,l_line_rec.line_id(I),NULL)

Line 1898: decode(z.config_item_id, z.ato_config_item_id, oe_order_lines_s.currval,NULL)

1894: REPLENISH_TO_ORDER_FLAG )
1895: SELECT
1896: oe_order_lines_s.nextval Line_id,
1897: l_line_rec.line_id(I) top_model_line_id,
1898: decode(z.config_item_id, z.ato_config_item_id, oe_order_lines_s.currval,NULL)
1899: ato_line_id,
1900: decode(z.config_item_id, z.ato_config_item_id,l_line_rec.line_id(I),NULL)
1901: link_to_line_id,
1902: l_line_rec.order_source_id(I) order_source_id,

Line 1904: 'OE_ORDER_LINES_ALL'||oe_order_lines_s.currval orig_sys_line_ref,

1900: decode(z.config_item_id, z.ato_config_item_id,l_line_rec.line_id(I),NULL)
1901: link_to_line_id,
1902: l_line_rec.order_source_id(I) order_source_id,
1903: l_line_rec.orig_sys_document_ref(I) orig_sys_document_ref,
1904: 'OE_ORDER_LINES_ALL'||oe_order_lines_s.currval orig_sys_line_ref,
1905: null orig_sys_shipment_ref,
1906: l_line_rec.orig_sys_line_ref(I) top_model_line_ref,
1907: z.inventory_item_id,
1908: -- NULL ordered_item,

Line 2721: oe_order_lines_s.nextval Line_id,

2717: LOCK_CONTROL,
2718: REPLENISH_TO_ORDER_FLAG
2719: )
2720: SELECT
2721: oe_order_lines_s.nextval Line_id,
2722: L.top_model_line_id top_model_line_id,
2723: L.ato_line_id ato_line_id,
2724: NULL link_to_line_id,
2725: l.order_source_id,

Line 2727: 'OE_ORDER_LINES_ALL'||oe_order_lines_s.currval orig_sys_line_ref,

2723: L.ato_line_id ato_line_id,
2724: NULL link_to_line_id,
2725: l.order_source_id,
2726: l.orig_sys_document_ref orig_sys_document_ref,
2727: 'OE_ORDER_LINES_ALL'||oe_order_lines_s.currval orig_sys_line_ref,
2728: l.orig_sys_line_ref top_model_line_ref,
2729: b.component_item_id,
2730: NULL ordered_item,
2731: b.primary_uom_code,

Line 2883: oe_order_lines_s.nextval Line_id,

2879: LOCK_CONTROL
2880: --REPLENISH_TO_ORDER_FLAG
2881: )
2882: SELECT
2883: oe_order_lines_s.nextval Line_id,
2884: L.top_model_line_id top_model_line_id,
2885: decode(z.config_item_id, z.ato_config_item_id,
2886: oe_order_lines_s.currval, NULL) ato_line_id ,
2887: NULL link_to_line_id,

Line 2886: oe_order_lines_s.currval, NULL) ato_line_id ,

2882: SELECT
2883: oe_order_lines_s.nextval Line_id,
2884: L.top_model_line_id top_model_line_id,
2885: decode(z.config_item_id, z.ato_config_item_id,
2886: oe_order_lines_s.currval, NULL) ato_line_id ,
2887: NULL link_to_line_id,
2888: L.order_source_id order_source_id,
2889: L.orig_sys_document_ref orig_sys_document_ref,
2890: 'OE_ORDER_LINES_ALL'||oe_order_lines_s.currval orig_sys_line_ref,

Line 2890: 'OE_ORDER_LINES_ALL'||oe_order_lines_s.currval orig_sys_line_ref,

2886: oe_order_lines_s.currval, NULL) ato_line_id ,
2887: NULL link_to_line_id,
2888: L.order_source_id order_source_id,
2889: L.orig_sys_document_ref orig_sys_document_ref,
2890: 'OE_ORDER_LINES_ALL'||oe_order_lines_s.currval orig_sys_line_ref,
2891: L.orig_sys_line_ref top_model_line_ref,
2892: z.inventory_item_id,
2893: z.uom_code,
2894: z.quantity,