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.GMD_VERSION_CONTROL dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 1682: SELECT MAX(SUBSTITUTION_VERSION) + 1 FROM GMD_ITEM_SUBSTITUTION_HDR_B

1678: WHERE substitution_id = p_substitution_id;
1679: X_hdr_rec Cur_get_hdr%ROWTYPE;
1680:
1681: CURSOR cur_hdr_ver IS
1682: SELECT MAX(SUBSTITUTION_VERSION) + 1 FROM GMD_ITEM_SUBSTITUTION_HDR_B
1683: WHERE SUBSTITUTION_NAME = X_hdr_rec.SUBSTITUTION_NAME;
1684: CURSOR cur_hdr_per IS
1685: SELECT MAX(preference) + 1 FROM GMD_ITEM_SUBSTITUTION_HDR_B
1686: WHERE ORIGINAL_INVENTORY_ITEM_ID = X_hdr_rec.ORIGINAL_INVENTORY_ITEM_ID

Line 1685: SELECT MAX(preference) + 1 FROM GMD_ITEM_SUBSTITUTION_HDR_B

1681: CURSOR cur_hdr_ver IS
1682: SELECT MAX(SUBSTITUTION_VERSION) + 1 FROM GMD_ITEM_SUBSTITUTION_HDR_B
1683: WHERE SUBSTITUTION_NAME = X_hdr_rec.SUBSTITUTION_NAME;
1684: CURSOR cur_hdr_per IS
1685: SELECT MAX(preference) + 1 FROM GMD_ITEM_SUBSTITUTION_HDR_B
1686: WHERE ORIGINAL_INVENTORY_ITEM_ID = X_hdr_rec.ORIGINAL_INVENTORY_ITEM_ID
1687: AND OWNER_ORGANIZATION_ID = X_hdr_rec.OWNER_ORGANIZATION_ID;
1688:
1689: CURSOR Cur_get_det IS