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 2354: mtl_item_revisions_b

2350: ) IS
2351: SELECT
2352: revision
2353: FROM
2354: mtl_item_revisions_b
2355: WHERE
2356: inventory_item_id = p_inventory_item_id AND
2357: organization_id = p_organization_id AND
2358: effectivity_date <= p_revision_date AND

Line 2404: mtl_item_revisions_b

2400: CURSOR c_efectivity_date IS
2401: SELECT
2402: effectivity_date
2403: FROM
2404: mtl_item_revisions_b
2405: WHERE
2406: inventory_item_id = p_inventory_item_id AND
2407: organization_id = p_organization_id
2408: ORDER BY

Line 2479: mtl_item_revisions_b

2475: attribute13,
2476: attribute14,
2477: attribute15
2478: FROM
2479: mtl_item_revisions_b
2480: WHERE
2481: inventory_item_id = p_inventory_item_id AND
2482: organization_id = p_organization_id AND
2483: effectivity_date <= p_revision_date AND

Line 2568: mtl_item_revisions_b mir,

2564:
2565: --To check if master orgs current reviison is already there in context org
2566: SELECT COUNT(1) INTO l_count
2567: FROM
2568: mtl_item_revisions_b mir,
2569: mtl_system_items_kfv msi
2570: WHERE
2571: mir.organization_id = msi.organization_id AND
2572: msi.organization_id = p_organization_id AND