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.ENG_LAUNCH_ECO_OI_PK dependencies on MTL_PARAMETERS

Line 3014: FROM mtl_parameters mp1

3010: --dbms_output.put_line('Set org ids');
3011: stmt_num := 3;
3012: UPDATE eng_eng_changes_interface eeci
3013: SET organization_id = (SELECT organization_id
3014: FROM mtl_parameters mp1
3015: WHERE mp1.organization_code = eeci.organization_code)
3016: WHERE process_flag = 1
3017: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3018: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3021: FROM mtl_parameters mp2

3017: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3018: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3019: AND organization_code is not null
3020: AND exists (SELECT organization_code
3021: FROM mtl_parameters mp2
3022: WHERE mp2.organization_code = eeci.organization_code);
3023:
3024: stmt_num := 4;
3025: UPDATE eng_eco_revisions_interface eeri

Line 3027: FROM mtl_parameters mp1

3023:
3024: stmt_num := 4;
3025: UPDATE eng_eco_revisions_interface eeri
3026: SET organization_id = (SELECT organization_id
3027: FROM mtl_parameters mp1
3028: WHERE mp1.organization_code = eeri.organization_code)
3029: WHERE process_flag = 1
3030: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3031: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3034: FROM mtl_parameters mp2

3030: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3031: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3032: AND organization_code is not null
3033: AND exists (SELECT organization_code
3034: FROM mtl_parameters mp2
3035: WHERE mp2.organization_code = eeri.organization_code);
3036:
3037: stmt_num := 5;
3038: UPDATE eng_revised_items_interface erii

Line 3040: FROM mtl_parameters mp1

3036:
3037: stmt_num := 5;
3038: UPDATE eng_revised_items_interface erii
3039: SET organization_id = (SELECT organization_id
3040: FROM mtl_parameters mp1
3041: WHERE mp1.organization_code = erii.organization_code)
3042: WHERE process_flag = 1
3043: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3044: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3047: FROM mtl_parameters mp2

3043: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3044: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3045: AND organization_code is not null
3046: AND exists (SELECT organization_code
3047: FROM mtl_parameters mp2
3048: WHERE mp2.organization_code = erii.organization_code);
3049:
3050:
3051: stmt_num := 6;

Line 3054: FROM mtl_parameters mp1

3050:
3051: stmt_num := 6;
3052: UPDATE bom_inventory_comps_interface bici
3053: SET organization_id = (SELECT organization_id
3054: FROM mtl_parameters mp1
3055: WHERE mp1.organization_code = bici.organization_code)
3056: WHERE process_flag = 1
3057: AND upper(transaction_type) in (G_Create, G_Delete, G_Update, G_Cancel)
3058: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3062: FROM mtl_parameters mp2

3058: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3059: AND interface_entity_type = 'ECO'
3060: AND organization_code is not null
3061: AND exists (SELECT organization_code
3062: FROM mtl_parameters mp2
3063: WHERE mp2.organization_code = bici.organization_code);
3064:
3065: stmt_num := 7;
3066: UPDATE bom_sub_comps_interface bsci

Line 3068: FROM mtl_parameters mp1

3064:
3065: stmt_num := 7;
3066: UPDATE bom_sub_comps_interface bsci
3067: SET organization_id = (SELECT organization_id
3068: FROM mtl_parameters mp1
3069: WHERE mp1.organization_code = bsci.organization_code)
3070: WHERE process_flag = 1
3071: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3072: AND interface_entity_type = 'ECO'

Line 3076: FROM mtl_parameters mp2

3072: AND interface_entity_type = 'ECO'
3073: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3074: AND organization_code is not null
3075: AND exists (SELECT organization_code
3076: FROM mtl_parameters mp2
3077: WHERE mp2.organization_code = bsci.organization_code);
3078:
3079: stmt_num := 8;
3080: UPDATE bom_ref_desgs_interface brdi

Line 3082: FROM mtl_parameters mp1

3078:
3079: stmt_num := 8;
3080: UPDATE bom_ref_desgs_interface brdi
3081: SET organization_id = (SELECT organization_id
3082: FROM mtl_parameters mp1
3083: WHERE mp1.organization_code = brdi.organization_code)
3084: WHERE process_flag = 1
3085: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3086: AND interface_entity_type = 'ECO'

Line 3090: FROM mtl_parameters mp2

3086: AND interface_entity_type = 'ECO'
3087: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3088: AND organization_code is not null
3089: AND exists (SELECT organization_code
3090: FROM mtl_parameters mp2
3091: WHERE mp2.organization_code = brdi.organization_code);
3092:
3093: stmt_num := 8.1;
3094: UPDATE bom_op_sequences_interface bosi

Line 3096: FROM mtl_parameters mp1

3092:
3093: stmt_num := 8.1;
3094: UPDATE bom_op_sequences_interface bosi
3095: SET organization_id = (SELECT organization_id
3096: FROM mtl_parameters mp1
3097: WHERE mp1.organization_code = bosi.organization_code)
3098: WHERE process_flag = 1
3099: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3100: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3103: FROM mtl_parameters mp2

3099: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3100: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3101: AND organization_code is not null
3102: AND exists (SELECT organization_code
3103: FROM mtl_parameters mp2
3104: WHERE mp2.organization_code = bosi.organization_code);
3105:
3106: stmt_num := 8.2;
3107: UPDATE bom_op_resources_interface bori

Line 3109: FROM mtl_parameters mp1

3105:
3106: stmt_num := 8.2;
3107: UPDATE bom_op_resources_interface bori
3108: SET organization_id = (SELECT organization_id
3109: FROM mtl_parameters mp1
3110: WHERE mp1.organization_code = bori.organization_code)
3111: WHERE process_flag = 1
3112: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3113: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3116: FROM mtl_parameters mp2

3112: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3113: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3114: AND organization_code is not null
3115: AND exists (SELECT organization_code
3116: FROM mtl_parameters mp2
3117: WHERE mp2.organization_code = bori.organization_code);
3118:
3119: stmt_num := 8.3;
3120: UPDATE bom_sub_op_resources_interface bsori

Line 3122: FROM mtl_parameters mp1

3118:
3119: stmt_num := 8.3;
3120: UPDATE bom_sub_op_resources_interface bsori
3121: SET organization_id = (SELECT organization_id
3122: FROM mtl_parameters mp1
3123: WHERE mp1.organization_code = bsori.organization_code)
3124: WHERE process_flag = 1
3125: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3126: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3129: FROM mtl_parameters mp2

3125: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3126: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3127: AND organization_code is not null
3128: AND exists (SELECT organization_code
3129: FROM mtl_parameters mp2
3130: WHERE mp2.organization_code = bsori.organization_code);
3131: stmt_num := 9;
3132: COMMIT;
3133: