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

Line 1754: FROM MTL_ITEM_REVISIONS_B

1750:
1751: CURSOR c_get_orig_item_rev_details (cp_inventory_item_id IN NUMBER
1752: ,cp_organization_id IN NUMBER) IS
1753: SELECT revision, revision_id
1754: FROM MTL_ITEM_REVISIONS_B
1755: WHERE inventory_item_id = cp_inventory_item_id
1756: AND organization_id = cp_organization_id
1757: AND effectivity_date <= SYSDATE
1758: ORDER BY effectivity_date desc;

Line 1771: l_item_rev_id mtl_item_revisions_b.revision_id%TYPE;

1767: l_new_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1768: l_orig_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1769: l_new_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1770: l_new_cc_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1771: l_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
1772: l_item_rev_code mtl_item_revisions_b.revision%TYPE;
1773: l_commit VARCHAR2(20);
1774:
1775: BEGIN

Line 1772: l_item_rev_code mtl_item_revisions_b.revision%TYPE;

1768: l_orig_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1769: l_new_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1770: l_new_cc_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1771: l_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
1772: l_item_rev_code mtl_item_revisions_b.revision%TYPE;
1773: l_commit VARCHAR2(20);
1774:
1775: BEGIN
1776: