eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_VALIDATE dependencies on OE_CONFIG_DETAILS_TMP

Line 2327: FROM oe_config_details_tmp L

2323: ,NULL ,NULL ,NULL
2324: ,'C' ,USERENV('LANG')
2325: ,l_msg_text || ' '|| l.ordered_item,
2326: OE_MSG_ID_S.NEXTVAL
2327: FROM oe_config_details_tmp L
2328: WHERE NVL(L.item_type_code, 'XXX') <> 'MODEL'
2329: AND NOT EXISTS (select L2.line_id
2330: From oe_config_details_tmp L2
2331: WHERE L2.component_code =

Line 2330: From oe_config_details_tmp L2

2326: OE_MSG_ID_S.NEXTVAL
2327: FROM oe_config_details_tmp L
2328: WHERE NVL(L.item_type_code, 'XXX') <> 'MODEL'
2329: AND NOT EXISTS (select L2.line_id
2330: From oe_config_details_tmp L2
2331: WHERE L2.component_code =
2332: substr(L.component_code,1,instr(L.component_code,'-',-1,1)-1)
2333: AND L2.top_model_line_id = L.top_model_line_id);
2334:

Line 2372: FROM oe_config_details_tmp L,

2368: ,l_msg_text ||' '||l.ordered_item || '( '||
2369: l.low_quantity*L2.ordered_quantity
2370: || ' -> '|| l.high_quantity *L2.ordered_quantity || ')',
2371: OE_MSG_ID_S.NEXTVAL
2372: FROM oe_config_details_tmp L,
2373: oe_config_details_tmp L2
2374: WHERE L2.item_type_code = 'MODEL'
2375: AND L.top_model_line_id = L2.line_id
2376: AND L.ordered_quantity > 0

Line 2373: oe_config_details_tmp L2

2369: l.low_quantity*L2.ordered_quantity
2370: || ' -> '|| l.high_quantity *L2.ordered_quantity || ')',
2371: OE_MSG_ID_S.NEXTVAL
2372: FROM oe_config_details_tmp L,
2373: oe_config_details_tmp L2
2374: WHERE L2.item_type_code = 'MODEL'
2375: AND L.top_model_line_id = L2.line_id
2376: AND L.ordered_quantity > 0
2377: AND L2.ordered_quantity > 0

Line 2414: FROM oe_config_details_tmp L

2410: ,NULL ,NULL ,NULL
2411: ,'C' ,USERENV('LANG')
2412: ,l_msg_text || ' '||l.ordered_item
2413: ,OE_MSG_ID_S.NEXTVAL
2414: FROM oe_config_details_tmp L
2415: WHERE L.BOM_ITEM_TYPE = 2
2416: AND L.ordered_quantity > 0
2417: AND NOT EXISTS ( -- fix bug 5687771
2418: select 1

Line 2419: from oe_config_details_tmp L2

2415: WHERE L.BOM_ITEM_TYPE = 2
2416: AND L.ordered_quantity > 0
2417: AND NOT EXISTS ( -- fix bug 5687771
2418: select 1
2419: from oe_config_details_tmp L2
2420: where L2.top_model_line_id = L.top_model_line_id
2421: and substr(L2.component_code, 1, instr(l2.component_code,'-',-1)-1) =
2422: L.component_code );
2423:

Line 2458: FROM oe_config_details_tmp L

2454: ,NULL ,NULL ,NULL
2455: ,'C' ,USERENV('LANG')
2456: ,l_msg_text || ' '||l.ordered_item
2457: ,OE_MSG_ID_S.NEXTVAL
2458: FROM oe_config_details_tmp L
2459: WHERE L.ITEM_TYPE_CODE in ('CLASS','MODEL')
2460: AND L.mutually_exclusive_options = 1
2461: AND 2 <= ( select count(line_id)
2462: From oe_config_details_tmp L2

Line 2462: From oe_config_details_tmp L2

2458: FROM oe_config_details_tmp L
2459: WHERE L.ITEM_TYPE_CODE in ('CLASS','MODEL')
2460: AND L.mutually_exclusive_options = 1
2461: AND 2 <= ( select count(line_id)
2462: From oe_config_details_tmp L2
2463: where --BUG 4586356 L2.item_type_code = 'OPTION'
2464: L.component_code = substr(L2.component_code, 1,
2465: instr(l2.component_code,'-',-1)-1)
2466: and L2.top_model_line_id = L.top_model_line_id);

Line 2500: FROM oe_config_details_tmp L

2496: ,NULL ,NULL ,NULL
2497: ,'C' ,USERENV('LANG')
2498: ,l_msg_text || ' '||l.ordered_item
2499: , OE_MSG_ID_S.NEXTVAL
2500: FROM oe_config_details_tmp L
2501: WHERE L.ITEM_TYPE_CODE = 'MODEL'
2502: AND EXISTS (select b2.component_code
2503: From bom_explosions b2
2504: Where b2.explosion_type = 'OPTIONAL'

Line 2513: From oe_config_details_tmp L2

2509: AND b2.bom_item_type IN ( 1, 2 ) -- Model, Class
2510: AND b2.optional = 2
2511: AND b2.component_code NOT IN (
2512: select component_code
2513: From oe_config_details_tmp L2
2514: Where L.top_model_line_id =
2515: L2.top_model_line_id)
2516: AND
2517: SUBSTR(B2.COMPONENT_CODE,1,INSTR(B2.COMPONENT_CODE,'-',-1,1)-1)

Line 2519: From oe_config_details_tmp L3

2515: L2.top_model_line_id)
2516: AND
2517: SUBSTR(B2.COMPONENT_CODE,1,INSTR(B2.COMPONENT_CODE,'-',-1,1)-1)
2518: IN ( select component_code
2519: From oe_config_details_tmp L3
2520: Where L.top_model_line_id =
2521: L3.top_model_line_id) );
2522:
2523: IF OE_BULK_VALIDATE.g_error_count = 0 THEN

Line 2573: FROM OE_HEADERS_IFACE_ALL a,OE_CONFIG_DETAILS_TMP t

2569: SET ERROR_FLAG = 'Y'
2570: ,ATTRIBUTE_STATUS = NULL
2571: WHERE (order_source_id, orig_sys_document_ref,orig_sys_line_ref) in
2572: (SELECT a.order_source_id, a.orig_sys_document_ref,t.orig_sys_line_ref
2573: FROM OE_HEADERS_IFACE_ALL a,OE_CONFIG_DETAILS_TMP t
2574: where a.batch_id=p_batch_id
2575: AND a.orig_sys_document_ref=t.orig_sys_document_ref
2576: AND a.order_source_id=t.order_source_id
2577: AND t.orig_sys_line_ref is not NULL

Line 2594: FROM OE_CONFIG_DETAILS_TMP t

2590: WHERE batch_id = p_batch_id
2591: AND nvl(ERROR_FLAG, 'N') = 'N'
2592: AND EXISTS
2593: (SELECT 'Y'
2594: FROM OE_CONFIG_DETAILS_TMP t
2595: WHERE t.orig_sys_document_ref = h.ORIG_SYS_DOCUMENT_REF
2596: AND t.order_source_id = h.order_source_id
2597: AND nvl(t.lock_control, 0) = -99);
2598: EXCEPTION