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_CONFIG_UTIL dependencies on OE_CONFIG_DETAILS_TMP

Line 1864: INSERT INTO oe_config_details_tmp

1860: -- iface(Case when only model line is specified and partial/none child
1861: -- lines are specified)
1862:
1863: -- insert missing child lines
1864: INSERT INTO oe_config_details_tmp
1865: (
1866: LINE_ID ,
1867: TOP_MODEL_LINE_ID,
1868: ATO_LINE_ID,

Line 1945: INSERT INTO oe_config_details_tmp

1941: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' MISSING CHILD TO TMP'||I , 3 ) ;
1942: END IF;
1943:
1944: -- insert lines from interface table
1945: INSERT INTO oe_config_details_tmp
1946: (
1947: LINE_ID ,
1948: TOP_MODEL_LINE_ID,
1949: ATO_LINE_ID,

Line 2613: -- Do BULK INSERT of all loaded lines into oe_config_details_tmp.

2609: p_config_rec => l_config_rec);
2610: END IF;
2611:
2612: -----------------------------------------------------------------
2613: -- Do BULK INSERT of all loaded lines into oe_config_details_tmp.
2614: -----------------------------------------------------------------
2615:
2616: IF nvl(p_use_configurator, 'N') = 'N' THEN
2617:

Line 2619: INSERT INTO oe_config_details_tmp

2615:
2616: IF nvl(p_use_configurator, 'N') = 'N' THEN
2617:
2618: FORALL I in 1..l_line_rec.line_id.COUNT
2619: INSERT INTO oe_config_details_tmp
2620: (
2621: LINE_ID ,
2622: TOP_MODEL_LINE_ID,
2623: ATO_LINE_ID,

Line 2688: INSERT INTO oe_config_details_tmp

2684: END IF;
2685:
2686:
2687: -- Insert Missing Classes
2688: INSERT INTO oe_config_details_tmp
2689: (
2690: LINE_ID ,
2691: TOP_MODEL_LINE_ID,
2692: ATO_LINE_ID,

Line 2745: oe_config_details_tmp L

2741: b.bom_item_type,
2742: null LOCK_CONTROL,
2743: b.replenish_to_order_flag
2744: FROM BOM_EXPLOSIONS b,
2745: oe_config_details_tmp L
2746: WHERE b.top_bill_sequence_id = L.top_bill_sequence_id
2747: AND L.item_type_code = 'MODEL'
2748: AND L.line_id = L.top_model_line_id
2749: AND nvl(L.lock_control, 0) <> -99

Line 2757: FROM oe_config_details_tmp l2

2753: AND nvl(b.disable_date, sysdate + 1) > sysdate
2754: AND b.component_sequence_id <> b.top_bill_sequence_id -- Exclude Model Lines
2755: AND b.component_code NOT IN (
2756: SELECT l2.component_code
2757: FROM oe_config_details_tmp l2
2758: WHERE l2.top_model_line_id = L.top_model_line_id )
2759: AND EXISTS (
2760: SELECT l3.line_id
2761: FROM oe_config_details_tmp l3

Line 2761: FROM oe_config_details_tmp l3

2757: FROM oe_config_details_tmp l2
2758: WHERE l2.top_model_line_id = L.top_model_line_id )
2759: AND EXISTS (
2760: SELECT l3.line_id
2761: FROM oe_config_details_tmp l3
2762: WHERE
2763: instr(l3.component_code, b.component_code, 1) = 1
2764: AND l3.top_model_line_id = L.top_model_line_id
2765: AND l3.item_type_code <> 'MODEL'

Line 2780: INSERT INTO oe_config_details_tmp

2776: -- cz_config_details_v for the new instance that just got created in
2777: -- Batch Validation call.
2778:
2779: FORALL I in 1..l_line_rec.line_id.COUNT
2780: INSERT INTO oe_config_details_tmp
2781: (
2782: LINE_ID ,
2783: TOP_MODEL_LINE_ID,
2784: ATO_LINE_ID,

Line 2850: -- missing in oe_config_details_tmp.

2846: END IF;
2847:
2848:
2849: -- Insert any new components that are present in CZ but
2850: -- missing in oe_config_details_tmp.
2851: INSERT INTO oe_config_details_tmp
2852: (
2853: LINE_ID ,
2854: TOP_MODEL_LINE_ID,

Line 2851: INSERT INTO oe_config_details_tmp

2847:
2848:
2849: -- Insert any new components that are present in CZ but
2850: -- missing in oe_config_details_tmp.
2851: INSERT INTO oe_config_details_tmp
2852: (
2853: LINE_ID ,
2854: TOP_MODEL_LINE_ID,
2855: ATO_LINE_ID,

Line 2906: oe_config_details_tmp L

2902: 'CLASS', -- In new configuration, only CLASS can be missing
2903: z.bom_item_type,
2904: null LOCK_CONTROL
2905: FROM CZ_CONFIG_DETAILS_V z,
2906: oe_config_details_tmp L
2907: WHERE L.item_type_code = 'MODEL'
2908: AND L.line_id = L.top_model_line_id
2909: AND nvl(L.lock_control, 0) <> -99
2910: AND L.config_header_id = z.config_hdr_id

Line 2914: FROM oe_config_details_tmp L2

2910: AND L.config_header_id = z.config_hdr_id
2911: AND L.config_rev_nbr = z.config_rev_nbr
2912: AND z.config_item_id NOT IN
2913: (Select configuration_id
2914: FROM oe_config_details_tmp L2
2915: WHERE L2.top_model_line_id = L.line_id);
2916:
2917: IF l_debug_level > 0 THEN
2918: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' TO TMP FROM CZ' , 3 ) ;

Line 3000: update oe_config_details_tmp L

2996: IF l_debug_level > 0 THEN
2997: oe_debug_pub.add( 'BEFORE update TMP for Config ') ;
2998: END IF;
2999:
3000: update oe_config_details_tmp L
3001: set ato_line_id =
3002: ( select ato_line_id
3003: from oe_config_details_tmp L1
3004: where L1.ato_line_id IS NOT NULL

Line 3003: from oe_config_details_tmp L1

2999:
3000: update oe_config_details_tmp L
3001: set ato_line_id =
3002: ( select ato_line_id
3003: from oe_config_details_tmp L1
3004: where L1.ato_line_id IS NOT NULL
3005: AND L1.top_model_line_id = L.top_model_line_id
3006: AND INSTR(L1.component_code,'-',1,2) = 0
3007: AND L1.component_code = decode( L1.item_type_code, 'MODEL',

Line 3037: UPDATE oe_config_details_tmp L

3033: IF l_debug_level > 0 THEN
3034: oe_debug_pub.add( 'BEFORE update TMP for Bom ') ;
3035: END IF;
3036:
3037: UPDATE oe_config_details_tmp L
3038: SET ato_line_id=
3039: ( SELECT L1.line_id
3040: FROM oe_config_details_tmp L1
3041: WHERE L.top_model_line_id = L1.top_model_line_id

Line 3040: FROM oe_config_details_tmp L1

3036:
3037: UPDATE oe_config_details_tmp L
3038: SET ato_line_id=
3039: ( SELECT L1.line_id
3040: FROM oe_config_details_tmp L1
3041: WHERE L.top_model_line_id = L1.top_model_line_id
3042: AND L1.top_model_line_id <> L1.line_id
3043: AND L1.bom_item_type = 1
3044: AND L1.replenish_to_order_flag = 'Y'

Line 3048: FROM oe_config_details_tmp L2

3044: AND L1.replenish_to_order_flag = 'Y'
3045: AND L1.component_code = SUBSTR( L.component_code, 1, LENGTH( L1.component_code ))
3046: AND L1.component_code =
3047: ( SELECT MIN( L2.component_code )
3048: FROM oe_config_details_tmp L2
3049: WHERE L2.top_model_line_id = L.top_model_line_id
3050: AND L2.component_code = SUBSTR( L.component_code, 1,
3051: LENGTH( L2.component_code ))
3052: AND L2.bom_item_type = 1

Line 3074: update oe_config_details_tmp L

3070: IF l_debug_level > 0 THEN
3071: oe_debug_pub.add( 'BEFORE update link_to_line_id ') ;
3072: END IF;
3073:
3074: update oe_config_details_tmp L
3075: SET link_to_line_id = (select line_id
3076: from oe_config_details_tmp L2
3077: where L2.component_code = substr(L.component_code,
3078: 1,instr(L.component_code,'-',-1,1)-1)

Line 3076: from oe_config_details_tmp L2

3072: END IF;
3073:
3074: update oe_config_details_tmp L
3075: SET link_to_line_id = (select line_id
3076: from oe_config_details_tmp L2
3077: where L2.component_code = substr(L.component_code,
3078: 1,instr(L.component_code,'-',-1,1)-1)
3079: and L2.top_model_line_id = L.top_model_line_id)
3080: where line_id <> top_model_line_id

Line 3146: from OE_CONFIG_DETAILS_TMP

3142: select config_header_id,
3143: config_rev_nbr,
3144: orig_sys_document_ref,
3145: order_source_id
3146: from OE_CONFIG_DETAILS_TMP
3147: where orig_sys_document_ref = p_orig_sys_document_ref
3148: and order_source_id = p_order_source_id
3149: and item_type_code = 'MODEL';
3150: