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 3020: FROM mtl_parameters mp1

3016: --dbms_output.put_line('Set org ids');
3017: stmt_num := 3;
3018: UPDATE eng_eng_changes_interface eeci
3019: SET organization_id = (SELECT organization_id
3020: FROM mtl_parameters mp1
3021: WHERE mp1.organization_code = eeci.organization_code)
3022: WHERE process_flag = 1
3023: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3024: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3027: FROM mtl_parameters mp2

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

Line 3033: FROM mtl_parameters mp1

3029:
3030: stmt_num := 4;
3031: UPDATE eng_eco_revisions_interface eeri
3032: SET organization_id = (SELECT organization_id
3033: FROM mtl_parameters mp1
3034: WHERE mp1.organization_code = eeri.organization_code)
3035: WHERE process_flag = 1
3036: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3037: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3040: FROM mtl_parameters mp2

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

Line 3046: FROM mtl_parameters mp1

3042:
3043: stmt_num := 5;
3044: UPDATE eng_revised_items_interface erii
3045: SET organization_id = (SELECT organization_id
3046: FROM mtl_parameters mp1
3047: WHERE mp1.organization_code = erii.organization_code)
3048: WHERE process_flag = 1
3049: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3050: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3053: FROM mtl_parameters mp2

3049: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3050: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3051: AND organization_code is not null
3052: AND exists (SELECT organization_code
3053: FROM mtl_parameters mp2
3054: WHERE mp2.organization_code = erii.organization_code);
3055:
3056:
3057: stmt_num := 6;

Line 3060: FROM mtl_parameters mp1

3056:
3057: stmt_num := 6;
3058: UPDATE bom_inventory_comps_interface bici
3059: SET organization_id = (SELECT organization_id
3060: FROM mtl_parameters mp1
3061: WHERE mp1.organization_code = bici.organization_code)
3062: WHERE process_flag = 1
3063: AND upper(transaction_type) in (G_Create, G_Delete, G_Update, G_Cancel)
3064: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3068: FROM mtl_parameters mp2

3064: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3065: AND interface_entity_type = 'ECO'
3066: AND organization_code is not null
3067: AND exists (SELECT organization_code
3068: FROM mtl_parameters mp2
3069: WHERE mp2.organization_code = bici.organization_code);
3070:
3071: stmt_num := 7;
3072: UPDATE bom_sub_comps_interface bsci

Line 3074: FROM mtl_parameters mp1

3070:
3071: stmt_num := 7;
3072: UPDATE bom_sub_comps_interface bsci
3073: SET organization_id = (SELECT organization_id
3074: FROM mtl_parameters mp1
3075: WHERE mp1.organization_code = bsci.organization_code)
3076: WHERE process_flag = 1
3077: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3078: AND interface_entity_type = 'ECO'

Line 3082: FROM mtl_parameters mp2

3078: AND interface_entity_type = 'ECO'
3079: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3080: AND organization_code is not null
3081: AND exists (SELECT organization_code
3082: FROM mtl_parameters mp2
3083: WHERE mp2.organization_code = bsci.organization_code);
3084:
3085: stmt_num := 8;
3086: UPDATE bom_ref_desgs_interface brdi

Line 3088: FROM mtl_parameters mp1

3084:
3085: stmt_num := 8;
3086: UPDATE bom_ref_desgs_interface brdi
3087: SET organization_id = (SELECT organization_id
3088: FROM mtl_parameters mp1
3089: WHERE mp1.organization_code = brdi.organization_code)
3090: WHERE process_flag = 1
3091: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3092: AND interface_entity_type = 'ECO'

Line 3096: FROM mtl_parameters mp2

3092: AND interface_entity_type = 'ECO'
3093: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3094: AND organization_code is not null
3095: AND exists (SELECT organization_code
3096: FROM mtl_parameters mp2
3097: WHERE mp2.organization_code = brdi.organization_code);
3098:
3099: stmt_num := 8.1;
3100: UPDATE bom_op_sequences_interface bosi

Line 3102: FROM mtl_parameters mp1

3098:
3099: stmt_num := 8.1;
3100: UPDATE bom_op_sequences_interface bosi
3101: SET organization_id = (SELECT organization_id
3102: FROM mtl_parameters mp1
3103: WHERE mp1.organization_code = bosi.organization_code)
3104: WHERE process_flag = 1
3105: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3106: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3109: FROM mtl_parameters mp2

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

Line 3115: FROM mtl_parameters mp1

3111:
3112: stmt_num := 8.2;
3113: UPDATE bom_op_resources_interface bori
3114: SET organization_id = (SELECT organization_id
3115: FROM mtl_parameters mp1
3116: WHERE mp1.organization_code = bori.organization_code)
3117: WHERE process_flag = 1
3118: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3119: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3122: FROM mtl_parameters mp2

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

Line 3128: FROM mtl_parameters mp1

3124:
3125: stmt_num := 8.3;
3126: UPDATE bom_sub_op_resources_interface bsori
3127: SET organization_id = (SELECT organization_id
3128: FROM mtl_parameters mp1
3129: WHERE mp1.organization_code = bsori.organization_code)
3130: WHERE process_flag = 1
3131: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3132: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)

Line 3135: FROM mtl_parameters mp2

3131: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3132: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3133: AND organization_code is not null
3134: AND exists (SELECT organization_code
3135: FROM mtl_parameters mp2
3136: WHERE mp2.organization_code = bsori.organization_code);
3137: stmt_num := 9;
3138: COMMIT;
3139: