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 397: 'MTL_ITEM_REVISIONS_INTERFACE',

393: request_id,
394: -1,
395: '*** BAD RETURN CODE e ***' || err_text,
396: null,
397: 'MTL_ITEM_REVISIONS_INTERFACE',
398: 'INV_IOI_ERR',
399: err_text);
400: ret_code := rtn_status;
401:

Line 4135: FROM mtl_item_revisions_interface

4131: --Fill Item Id for Item Number
4132: CURSOR c_fill_Item_Id IS
4133: SELECT DISTINCT item_number,
4134: organization_id
4135: FROM mtl_item_revisions_interface
4136: WHERE inventory_item_id IS NULL
4137: AND item_number IS NOT NULL
4138: AND organization_id IS NOT NULL
4139: AND set_process_id = xset_id

Line 4147: FROM mtl_item_revisions_interface

4143: CURSOR c_fill_transaction_id IS
4144: SELECT distinct inventory_item_id,
4145: organization_id,
4146: transaction_type
4147: FROM mtl_item_revisions_interface
4148: WHERE process_flag = 1
4149: AND set_process_id = xset_id
4150: AND transaction_id IS NULL --Bug: 3019435 Added condition
4151: AND (organization_id = org_id or all_org = 1);

Line 4185: FROM mtl_item_revisions_interface

4181: ,attribute15
4182: ,revision_label
4183: ,revision_reason
4184: ,transaction_id
4185: FROM mtl_item_revisions_interface
4186: WHERE process_flag = 1
4187: AND set_process_id = xset_id
4188: AND (organization_id = org_id or all_org = 1);
4189:

Line 4221: FROM mtl_item_revisions

4217: ,revision_reason
4218: ,revised_item_sequence_id
4219: ,lifecycle_id
4220: ,current_phase_id
4221: FROM mtl_item_revisions
4222: WHERE organization_id = cp_org_id
4223: AND inventory_item_id = cp_item_id
4224: AND revision = cp_revision;
4225:

Line 4243: UPDATE mtl_item_revisions_interface i

4239:
4240: BEGIN
4241:
4242: --Assign Orgnization Id for missing ones
4243: UPDATE mtl_item_revisions_interface i
4244: SET i.organization_id = (SELECT o.organization_id
4245: FROM mtl_parameters o
4246: WHERE o.organization_code = i.organization_code)
4247: WHERE i.organization_id is NULL

Line 4260: UPDATE mtl_item_revisions_interface

4256: cr.item_number, flex_id,
4257: 0, err_text);
4258: IF status <> 0 THEN
4259: ----Bug: 3019435 Changed the code with in IF st.
4260: UPDATE mtl_item_revisions_interface
4261: SET process_flag = l_process_flag_3,
4262: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
4263: WHERE item_number = cr.item_number
4264: AND inventory_item_id IS NULL

Line 4284: 'MTL_ITEM_REVISIONS_INTERFACE',

4280: request_id,
4281: tran_id,
4282: err_text,
4283: 'item_number',
4284: 'MTL_ITEM_REVISIONS_INTERFACE',
4285: 'BOM_OP_VALIDATION_ERR',
4286: err_text);
4287: IF dumm_status < 0 THEN
4288: raise LOGGING_ERROR ;

Line 4291: /* UPDATE mtl_item_revisions_interface

4287: IF dumm_status < 0 THEN
4288: raise LOGGING_ERROR ;
4289: END IF;
4290:
4291: /* UPDATE mtl_item_revisions_interface
4292: SET process_flag = l_process_flag_3,
4293: transaction_id = tran_id
4294: WHERE item_number = cr.item_number
4295: AND inventory_item_id IS NULL

Line 4306: UPDATE mtl_item_revisions_interface

4302: END IF;
4303:
4304: ELSIF status = 0 THEN
4305:
4306: UPDATE mtl_item_revisions_interface
4307: SET inventory_item_id = flex_id
4308: WHERE item_number = cr.item_number
4309: AND set_process_id = xset_id
4310: AND organization_id = cr.organization_id;

Line 4322: UPDATE mtl_item_revisions_interface

4318:
4319: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4320: INTO tran_id FROM dual;
4321:
4322: UPDATE mtl_item_revisions_interface
4323: SET transaction_id = tran_id
4324: WHERE inventory_item_id = cr.inventory_item_id
4325: AND organization_id = cr.organization_id
4326: AND transaction_type = cr.transaction_type

Line 4351: UPDATE mtl_item_revisions_interface

4347: WHERE organization_id = cr.organization_id;
4348:
4349: IF l_default_revision = cr.revision THEN
4350:
4351: UPDATE mtl_item_revisions_interface
4352: SET effectivity_date = l_rev_rec.effectivity_date
4353: WHERE rowid = cr.rowid;
4354:
4355: END IF;

Line 4358: UPDATE mtl_item_revisions_interface

4354:
4355: END IF;
4356:
4357:
4358: UPDATE mtl_item_revisions_interface
4359: SET revision_id = l_rev_rec.revision_id
4360: ,description = decode(description,NULL,l_rev_rec.description,'!',NULL,g_FND_Upd_Null_Char,NULL,description)
4361: ,change_notice = l_rev_rec.change_notice
4362: ,ecn_initiation_date = l_rev_rec.ecn_initiation_date

Line 4401: 'MTL_ITEM_REVISIONS_INTERFACE',

4397: request_id,
4398: cr.transaction_id,
4399: err_text,
4400: 'REVISION',
4401: 'MTL_ITEM_REVISIONS_INTERFACE',
4402: 'INV_INVALID_REVISION',
4403: err_text);
4404: IF dumm_status < 0 THEN
4405: raise LOGGING_ERROR ;

Line 4408: UPDATE mtl_item_revisions_interface

4404: IF dumm_status < 0 THEN
4405: raise LOGGING_ERROR ;
4406: END IF;
4407:
4408: UPDATE mtl_item_revisions_interface
4409: SET process_flag = l_process_flag_3
4410: WHERE rowid = cr.rowid;
4411:
4412: END IF;

Line 4417: UPDATE mtl_item_revisions_interface

4413:
4414: END LOOP; --Revision defaults fill LOOP
4415:
4416: --Update process flag , at last
4417: UPDATE mtl_item_revisions_interface
4418: SET process_flag = l_process_flag_2 ,
4419: last_update_date = l_sysdate,
4420: last_updated_by = decode(last_updated_by,NULL,user_id,last_updated_by),
4421: creation_date = l_sysdate,

Line 4433: UPDATE mtl_item_revisions_interface i

4429: AND set_process_id = xset_id
4430: AND (organization_id = org_id or all_org = l_all_org);
4431:
4432: --Set process flag for the records with errors
4433: UPDATE mtl_item_revisions_interface i
4434: SET i.process_flag = l_process_flag_3,
4435: i.last_update_date = sysdate,
4436: i.last_updated_by = decode(i.last_updated_by, NULL, user_id,i.last_updated_by),
4437: i.creation_date = l_sysdate,