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 906: FROM mtl_item_revisions_b mir

902: ,FND_GLOBAL.conc_request_id
903: ,FND_GLOBAL.prog_appl_id
904: ,FND_GLOBAL.conc_program_id
905: ,SYSDATE
906: FROM mtl_item_revisions_b mir
907: ,mtl_system_items_interface msi
908: WHERE mir.inventory_item_id = msi.inventory_item_id
909: and mir.organization_id = p_source_org_id
910: and msi.organization_id = p_target_org_id

Line 916: the sequence 'MTL_ITEM_REVISIONS_B_S';

912: ORDER BY mir.REVISION,effectivity_date ;
913:
914: /*myerrams,
915: Following code is to update mtl_item_revisions_interface table with Revision Id, which is generated using
916: the sequence 'MTL_ITEM_REVISIONS_B_S';
917: Bug: 4892069
918: */
919: IF p_validate = 'N'
920: THEN

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

931: FETCH c_item_rev_update_cursor into l_org_id, l_inv_item_id, l_revision;
932: EXIT WHEN c_item_rev_update_cursor%NOTFOUND;
933:
934: --Get the new Revision Id from Sequence.
935: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;
936:
937: --Update Inferface table with mandatroy Revision Id Attribute.
938: UPDATE mtl_item_revisions_interface
939: SET revision_id = l_revision_id