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.INV_COPY_ITEM_CP dependencies on MTL_ITEM_REVISIONS_B

Line 926: FROM mtl_item_revisions_b mir

922: ,FND_GLOBAL.conc_request_id
923: ,FND_GLOBAL.prog_appl_id
924: ,FND_GLOBAL.conc_program_id
925: ,SYSDATE
926: FROM mtl_item_revisions_b mir
927: ,mtl_system_items_interface msi
928: WHERE mir.inventory_item_id = msi.inventory_item_id
929: and mir.organization_id = p_source_org_id
930: and msi.organization_id = p_target_org_id

Line 936: the sequence 'MTL_ITEM_REVISIONS_B_S';

932: ORDER BY mir.REVISION,effectivity_date ;
933:
934: /*myerrams,
935: Following code is to update mtl_item_revisions_interface table with Revision Id, which is generated using
936: the sequence 'MTL_ITEM_REVISIONS_B_S';
937: Bug: 4892069
938: */
939: IF p_validate = 'N'
940: THEN

Line 955: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;

951: FETCH c_item_rev_update_cursor into l_org_id, l_inv_item_id, l_revision;
952: EXIT WHEN c_item_rev_update_cursor%NOTFOUND;
953:
954: --Get the new Revision Id from Sequence.
955: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;
956:
957: --Update Inferface table with mandatroy Revision Id Attribute.
958: UPDATE mtl_item_revisions_interface
959: SET revision_id = l_revision_id