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.INVUPD1B dependencies on MTL_ITEM_REVISIONS

Line 413: 'MTL_ITEM_REVISIONS_INTERFACE',

409: request_id,
410: -1,
411: '*** BAD RETURN CODE e ***' || err_text,
412: null,
413: 'MTL_ITEM_REVISIONS_INTERFACE',
414: 'INV_IOI_ERR_E_ASS_ITM_RVS', --bug 11894684, replace INV_IOI_ERR
415: err_text);
416: ret_code := rtn_status;
417:

Line 4162: FROM mtl_item_revisions_interface

4158: --Fill Item Id for Item Number
4159: CURSOR c_fill_Item_Id IS
4160: SELECT DISTINCT item_number,
4161: organization_id
4162: FROM mtl_item_revisions_interface
4163: WHERE inventory_item_id IS NULL
4164: AND item_number IS NOT NULL
4165: AND organization_id IS NOT NULL
4166: AND set_process_id = xset_id

Line 4174: FROM mtl_item_revisions_interface

4170: CURSOR c_fill_transaction_id IS
4171: SELECT distinct inventory_item_id,
4172: organization_id,
4173: transaction_type
4174: FROM mtl_item_revisions_interface
4175: WHERE process_flag = 1
4176: AND set_process_id = xset_id
4177: AND transaction_id IS NULL --Bug: 3019435 Added condition
4178: AND (organization_id = org_id or all_org = 1);

Line 4212: FROM mtl_item_revisions_interface

4208: ,attribute15
4209: ,revision_label
4210: ,revision_reason
4211: ,transaction_id
4212: FROM mtl_item_revisions_interface
4213: WHERE process_flag = 1
4214: AND set_process_id = xset_id
4215: AND (organization_id = org_id or all_org = 1);
4216:

Line 4248: FROM mtl_item_revisions

4244: ,revision_reason
4245: ,revised_item_sequence_id
4246: ,lifecycle_id
4247: ,current_phase_id
4248: FROM mtl_item_revisions
4249: WHERE organization_id = cp_org_id
4250: AND inventory_item_id = cp_item_id
4251: AND revision = cp_revision;
4252:

Line 4270: UPDATE mtl_item_revisions_interface i

4266:
4267: BEGIN
4268:
4269: --Assign Orgnization Id for missing ones
4270: UPDATE mtl_item_revisions_interface i
4271: SET i.organization_id = (SELECT o.organization_id
4272: FROM mtl_parameters o
4273: WHERE o.organization_code = i.organization_code)
4274: WHERE i.organization_id is NULL

Line 4287: UPDATE mtl_item_revisions_interface

4283: cr.item_number, flex_id,
4284: 0, err_text);
4285: IF status <> 0 THEN
4286: ----Bug: 3019435 Changed the code with in IF st.
4287: UPDATE mtl_item_revisions_interface
4288: SET process_flag = l_process_flag_3,
4289: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
4290: WHERE item_number = cr.item_number
4291: AND inventory_item_id IS NULL

Line 4311: 'MTL_ITEM_REVISIONS_INTERFACE',

4307: request_id,
4308: tran_id,
4309: err_text,
4310: 'item_number',
4311: 'MTL_ITEM_REVISIONS_INTERFACE',
4312: 'BOM_OP_VALIDATION_ERR',
4313: err_text);
4314: IF dumm_status < 0 THEN
4315: raise LOGGING_ERROR ;

Line 4318: /* UPDATE mtl_item_revisions_interface

4314: IF dumm_status < 0 THEN
4315: raise LOGGING_ERROR ;
4316: END IF;
4317:
4318: /* UPDATE mtl_item_revisions_interface
4319: SET process_flag = l_process_flag_3,
4320: transaction_id = tran_id
4321: WHERE item_number = cr.item_number
4322: AND inventory_item_id IS NULL

Line 4333: UPDATE mtl_item_revisions_interface

4329: END IF;
4330:
4331: ELSIF status = 0 THEN
4332:
4333: UPDATE mtl_item_revisions_interface
4334: SET inventory_item_id = flex_id
4335: WHERE item_number = cr.item_number
4336: AND set_process_id = xset_id
4337: AND organization_id = cr.organization_id;

Line 4349: UPDATE mtl_item_revisions_interface

4345:
4346: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4347: INTO tran_id FROM dual;
4348:
4349: UPDATE mtl_item_revisions_interface
4350: SET transaction_id = tran_id
4351: WHERE inventory_item_id = cr.inventory_item_id
4352: AND organization_id = cr.organization_id
4353: AND transaction_type = cr.transaction_type

Line 4379: UPDATE mtl_item_revisions_interface

4375: WHERE organization_id = cr.organization_id;
4376:
4377: IF l_default_revision = cr.revision THEN
4378:
4379: UPDATE mtl_item_revisions_interface
4380: SET effectivity_date = l_rev_rec.effectivity_date
4381: WHERE rowid = cr.rowid;
4382:
4383: END IF;

Line 4386: UPDATE mtl_item_revisions_interface

4382:
4383: END IF;
4384:
4385:
4386: UPDATE mtl_item_revisions_interface
4387: SET revision_id = l_rev_rec.revision_id
4388: ,description = decode(description,NULL,l_rev_rec.description,'!',NULL,g_FND_Upd_Null_Char,NULL,description)
4389: ,change_notice = l_rev_rec.change_notice
4390: ,ecn_initiation_date = l_rev_rec.ecn_initiation_date

Line 4429: 'MTL_ITEM_REVISIONS_INTERFACE',

4425: request_id,
4426: cr.transaction_id,
4427: err_text,
4428: 'REVISION',
4429: 'MTL_ITEM_REVISIONS_INTERFACE',
4430: 'INV_INVALID_REVISION',
4431: err_text);
4432: IF dumm_status < 0 THEN
4433: raise LOGGING_ERROR ;

Line 4436: UPDATE mtl_item_revisions_interface

4432: IF dumm_status < 0 THEN
4433: raise LOGGING_ERROR ;
4434: END IF;
4435:
4436: UPDATE mtl_item_revisions_interface
4437: SET process_flag = l_process_flag_3
4438: WHERE rowid = cr.rowid;
4439:
4440: END IF;

Line 4445: UPDATE mtl_item_revisions_interface

4441:
4442: END LOOP; --Revision defaults fill LOOP
4443:
4444: --Update process flag , at last
4445: UPDATE mtl_item_revisions_interface
4446: SET process_flag = l_process_flag_2 ,
4447: last_update_date = l_sysdate,
4448: last_updated_by = decode(last_updated_by,NULL,user_id,last_updated_by),
4449: creation_date = l_sysdate,

Line 4461: UPDATE mtl_item_revisions_interface i

4457: AND set_process_id = xset_id
4458: AND (organization_id = org_id or all_org = l_all_org);
4459:
4460: --Set process flag for the records with errors
4461: UPDATE mtl_item_revisions_interface i
4462: SET i.process_flag = l_process_flag_3,
4463: i.last_update_date = sysdate,
4464: i.last_updated_by = decode(i.last_updated_by, NULL, user_id,i.last_updated_by),
4465: i.creation_date = l_sysdate,