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

Line 48: FROM mtl_item_revisions_b

44: , p_organization_id NUMBER
45: , p_revision VARCHAR2
46: ) IS
47: SELECT object_version_number
48: FROM mtl_item_revisions_b
49: WHERE
50: inventory_item_id = p_inventory_item_id
51: AND organization_id = p_organization_id
52: AND revision = p_revision;

Line 62: FROM mtl_item_revisions_b

58: , p_revision VARCHAR2
59: , p_revision_id NUMBER
60: ) IS
61: SELECT object_version_number
62: FROM mtl_item_revisions_b
63: WHERE
64: inventory_item_id = p_inventory_item_id
65: AND organization_id = p_organization_id
66: AND revision = p_revision

Line 76: FROM mtl_item_revisions_b

72: , p_organization_id NUMBER
73: , p_revision_id NUMBER
74: ) IS
75: SELECT object_version_number
76: FROM mtl_item_revisions_b
77: WHERE
78: inventory_item_id = p_inventory_item_id
79: AND organization_id = p_organization_id
80: AND revision_id = p_revision_id;

Line 200: FROM mtl_item_revisions_b

196:
197: CURSOR Item_Revs_cur
198: IS
199: SELECT revision, effectivity_date
200: FROM mtl_item_revisions_b
201: WHERE
202: inventory_item_id = p_Item_Revision_rec.inventory_item_id
203: AND organization_id = p_Item_Revision_rec.organization_id
204: AND revision_id <> NVL(p_Item_Revision_rec.revision_id,-999999) --3655522 & 7248982:API taking same effectivity date

Line 208: v_revision mtl_item_revisions_b.revision%TYPE;

204: AND revision_id <> NVL(p_Item_Revision_rec.revision_id,-999999) --3655522 & 7248982:API taking same effectivity date
205: ORDER BY
206: revision, effectivity_date;
207:
208: v_revision mtl_item_revisions_b.revision%TYPE;
209: v_effectivity_date mtl_item_revisions_b.effectivity_date%TYPE;
210:
211: v_count NUMBER;
212: rev_place_found BOOLEAN;

Line 209: v_effectivity_date mtl_item_revisions_b.effectivity_date%TYPE;

205: ORDER BY
206: revision, effectivity_date;
207:
208: v_revision mtl_item_revisions_b.revision%TYPE;
209: v_effectivity_date mtl_item_revisions_b.effectivity_date%TYPE;
210:
211: v_count NUMBER;
212: rev_place_found BOOLEAN;
213:

Line 435: FROM mtl_item_revisions_b

431: CURSOR c_get_effective_revision(cp_inventory_item_id NUMBER
432: ,cp_organization_id NUMBER
433: ,cp_revision VARCHAR2) IS
434: SELECT revision_id
435: FROM mtl_item_revisions_b
436: WHERE inventory_item_id = cp_inventory_item_id
437: AND organization_id = cp_organization_id
438: AND revision < cp_revision
439: AND implementation_date IS NOT NULL

Line 447: FROM mtl_item_revisions_b

443: CURSOR c_is_source_revision_valid(cp_inventory_item_id NUMBER
444: ,cp_organization_id NUMBER
445: ,cp_source_revision_id NUMBER) IS
446: SELECT revision_id
447: FROM mtl_item_revisions_b
448: WHERE inventory_item_id = cp_inventory_item_id
449: AND organization_id = cp_organization_id
450: AND revision_id = cp_source_revision_id;
451:

Line 452: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;

448: WHERE inventory_item_id = cp_inventory_item_id
449: AND organization_id = cp_organization_id
450: AND revision_id = cp_source_revision_id;
451:
452: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;
453: l_return_status VARCHAR2(100);
454: l_error_code NUMBER;
455: l_msg_count NUMBER ;
456: l_msg_data VARCHAR2(100);

Line 876: SELECT mtl_item_revisions_b_s.CURRVAL

872: END IF;
873:
874: IF p_Item_Revision_rec.revision_id IS NOT NULL THEN
875: BEGIN
876: SELECT mtl_item_revisions_b_s.CURRVAL
877: INTO l_revision_id FROM DUAL;
878: IF p_Item_Revision_rec.revision_id > l_revision_id THEN
879: Add_Message ('INV', 'INV_INVALID_REVISION_ID');
880: RAISE FND_API.g_EXC_ERROR;

Line 891: SELECT mtl_item_revisions_b_s.NEXTVAL

887: END IF;
888:
889: IF p_Item_Revision_rec.revision_id IS NULL THEN
890:
891: SELECT mtl_item_revisions_b_s.NEXTVAL
892: INTO p_Item_Revision_rec.revision_id
893: FROM DUAL;
894:
895: END IF;

Line 899: INSERT INTO mtl_item_revisions_b

895: END IF;
896:
897: --INV_ITEM_MSG.Debug(Mctx, 'INSERT INTO mtl_item_revisions table');
898:
899: INSERT INTO mtl_item_revisions_b
900: (
901: inventory_item_id
902: , organization_id
903: , revision_id

Line 1238: FROM mtl_item_revisions_b

1234: SELECT effectivity_date
1235: ,implementation_date
1236: ,lifecycle_id
1237: ,current_phase_id
1238: FROM mtl_item_revisions_b
1239: WHERE inventory_item_id = p_inventory_item_id
1240: AND organization_id = p_organization_id
1241: AND revision = p_revision;
1242:

Line 1660: UPDATE mtl_item_revisions_b

1656:
1657:
1658: --INV_ITEM_MSG.Debug(Mctx, 'UPDATE mtl_item_revisions table');
1659:
1660: UPDATE mtl_item_revisions_b
1661: SET
1662: revision = DECODE(p_Item_Revision_rec.revision, G_Miss_Char, revision, null, revision, p_Item_Revision_rec.revision )
1663: , change_notice = DECODE(p_Item_Revision_rec.change_notice, G_Miss_Char, null, null, change_notice, p_Item_Revision_rec.change_notice )
1664: , ecn_initiation_date = DECODE(p_Item_Revision_rec.ecn_initiation_date, G_Miss_Date, null, null, ecn_initiation_date, p_Item_Revision_rec.ecn_initiation_date )

Line 1919: FROM mtl_item_revisions_b

1915: , p_organization_id NUMBER
1916: , p_revision VARCHAR2
1917: ) IS
1918: SELECT object_version_number
1919: FROM mtl_item_revisions_b
1920: WHERE
1921: inventory_item_id = p_inventory_item_id
1922: AND organization_id = p_organization_id
1923: AND revision = p_revision

Line 2139: DELETE FROM mtl_item_revisions_b

2135: END IF;
2136:
2137: --dbms_output.put_line('DELETE FROM mtl_item_revisions; x_return_status = ' || x_return_status);
2138:
2139: DELETE FROM mtl_item_revisions_b
2140: WHERE
2141: inventory_item_id = p_inventory_item_id
2142: AND organization_id = p_organization_id
2143: AND revision = p_revision