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_EBI_CHANGE_ORDER_HELPER dependencies on MTL_ITEM_REVISIONS_B

Line 507: mtl_item_revisions_b

503: CURSOR c_efectivity_date IS
504: SELECT
505: effectivity_date
506: FROM
507: mtl_item_revisions_b
508: WHERE
509: inventory_item_id = p_inventory_item_id AND
510: organization_id = p_organization_id AND
511: (p_new_revision IS NULL -- Added for bug 14032254,the "IS NULL" condition along with

Line 3222: mtl_item_revisions_b

3218: ) IS
3219: SELECT
3220: revision
3221: FROM
3222: mtl_item_revisions_b
3223: WHERE
3224: inventory_item_id = p_inventory_item_id AND
3225: organization_id = p_organization_id AND
3226: effectivity_date <= p_revision_date AND

Line 3308: mtl_item_revisions_b

3304: attribute13,
3305: attribute14,
3306: attribute15
3307: FROM
3308: mtl_item_revisions_b
3309: WHERE
3310: inventory_item_id = p_inventory_item_id AND
3311: organization_id = p_organization_id AND
3312: effectivity_date <= p_revision_date AND

Line 3402: mtl_item_revisions_b mir,

3398:
3399: --To check if master orgs current reviison is already there in context org
3400: SELECT COUNT(1) INTO l_count
3401: FROM
3402: mtl_item_revisions_b mir,
3403: mtl_system_items_kfv msi
3404: WHERE
3405: mir.organization_id = msi.organization_id AND
3406: msi.organization_id = p_organization_id AND