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 64: FROM mtl_item_revisions_b

60: , p_organization_id NUMBER
61: , p_revision VARCHAR2
62: ) IS
63: SELECT ascii(p_revision) - ascii(Max(revision))
64: FROM mtl_item_revisions_b
65: WHERE inventory_item_id=p_inventory_item_id
66: AND organization_id=p_organization_id;
67: */
68: /*End of changes for bug 13905125

Line 79: FROM mtl_item_revisions_b

75: , p_revision VARCHAR2
76: , p_revision_id NUMBER
77: ) IS
78: SELECT object_version_number
79: FROM mtl_item_revisions_b
80: WHERE
81: inventory_item_id = p_inventory_item_id
82: AND organization_id = p_organization_id
83: AND revision = p_revision

Line 93: FROM mtl_item_revisions_b

89: , p_organization_id NUMBER
90: , p_revision_id NUMBER
91: ) IS
92: SELECT object_version_number
93: FROM mtl_item_revisions_b
94: WHERE
95: inventory_item_id = p_inventory_item_id
96: AND organization_id = p_organization_id
97: AND revision_id = p_revision_id;

Line 217: FROM mtl_item_revisions_b

213:
214: CURSOR Item_Revs_cur
215: IS
216: SELECT revision, effectivity_date
217: FROM mtl_item_revisions_b
218: WHERE
219: inventory_item_id = p_Item_Revision_rec.inventory_item_id
220: AND organization_id = p_Item_Revision_rec.organization_id
221: AND revision_id <> NVL(p_Item_Revision_rec.revision_id,-999999) --3655522 , 7248982:API taking same effectivity date

Line 225: v_revision mtl_item_revisions_b.revision%TYPE;

221: AND revision_id <> NVL(p_Item_Revision_rec.revision_id,-999999) --3655522 , 7248982:API taking same effectivity date
222: ORDER BY
223: revision, effectivity_date;
224:
225: v_revision mtl_item_revisions_b.revision%TYPE;
226: v_effectivity_date mtl_item_revisions_b.effectivity_date%TYPE;
227:
228: v_count NUMBER;
229: rev_place_found BOOLEAN;

Line 226: v_effectivity_date mtl_item_revisions_b.effectivity_date%TYPE;

222: ORDER BY
223: revision, effectivity_date;
224:
225: v_revision mtl_item_revisions_b.revision%TYPE;
226: v_effectivity_date mtl_item_revisions_b.effectivity_date%TYPE;
227:
228: v_count NUMBER;
229: rev_place_found BOOLEAN;
230:

Line 452: FROM mtl_item_revisions_b

448: CURSOR c_get_effective_revision(cp_inventory_item_id NUMBER
449: ,cp_organization_id NUMBER
450: ,cp_revision VARCHAR2) IS
451: SELECT revision_id
452: FROM mtl_item_revisions_b
453: WHERE inventory_item_id = cp_inventory_item_id
454: AND organization_id = cp_organization_id
455: AND revision < cp_revision
456: AND implementation_date IS NOT NULL

Line 464: FROM mtl_item_revisions_b

460: CURSOR c_is_source_revision_valid(cp_inventory_item_id NUMBER
461: ,cp_organization_id NUMBER
462: ,cp_source_revision_id NUMBER) IS
463: SELECT revision_id
464: FROM mtl_item_revisions_b
465: WHERE inventory_item_id = cp_inventory_item_id
466: AND organization_id = cp_organization_id
467: AND revision_id = cp_source_revision_id;
468:

Line 469: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;

465: WHERE inventory_item_id = cp_inventory_item_id
466: AND organization_id = cp_organization_id
467: AND revision_id = cp_source_revision_id;
468:
469: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;
470: l_return_status VARCHAR2(100);
471: l_error_code NUMBER;
472: l_msg_count NUMBER ;
473: l_msg_data VARCHAR2(100);

Line 931: SELECT mtl_item_revisions_b_s.CURRVAL

927: END IF;
928:
929: IF p_Item_Revision_rec.revision_id IS NOT NULL THEN
930: BEGIN
931: SELECT mtl_item_revisions_b_s.CURRVAL
932: INTO l_revision_id FROM DUAL;
933: IF p_Item_Revision_rec.revision_id > l_revision_id THEN
934: Add_Message ('INV', 'INV_INVALID_REVISION_ID');
935: RAISE FND_API.g_EXC_ERROR;

Line 946: SELECT mtl_item_revisions_b_s.NEXTVAL

942: END IF;
943:
944: IF p_Item_Revision_rec.revision_id IS NULL THEN
945:
946: SELECT mtl_item_revisions_b_s.NEXTVAL
947: INTO p_Item_Revision_rec.revision_id
948: FROM DUAL;
949:
950: END IF;

Line 954: INSERT INTO mtl_item_revisions_b

950: END IF;
951:
952: --INV_ITEM_MSG.Debug(Mctx, 'INSERT INTO mtl_item_revisions table');
953:
954: INSERT INTO mtl_item_revisions_b
955: (
956: inventory_item_id
957: , organization_id
958: , revision_id

Line 1300: FROM mtl_item_revisions_b

1296: SELECT effectivity_date
1297: ,implementation_date
1298: ,lifecycle_id
1299: ,current_phase_id
1300: FROM mtl_item_revisions_b
1301: WHERE inventory_item_id = p_inventory_item_id
1302: AND organization_id = p_organization_id
1303: AND revision = p_revision;
1304:

Line 1722: UPDATE mtl_item_revisions_b

1718:
1719:
1720: --INV_ITEM_MSG.Debug(Mctx, 'UPDATE mtl_item_revisions table');
1721:
1722: UPDATE mtl_item_revisions_b
1723: SET
1724: revision = DECODE(p_Item_Revision_rec.revision, G_Miss_Char, revision, null, revision, p_Item_Revision_rec.revision )
1725: , change_notice = DECODE(p_Item_Revision_rec.change_notice, G_Miss_Char, null, null, change_notice, p_Item_Revision_rec.change_notice )
1726: , 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 1981: FROM mtl_item_revisions_b

1977: , p_organization_id NUMBER
1978: , p_revision VARCHAR2
1979: ) IS
1980: SELECT object_version_number
1981: FROM mtl_item_revisions_b
1982: WHERE
1983: inventory_item_id = p_inventory_item_id
1984: AND organization_id = p_organization_id
1985: AND revision = p_revision

Line 2201: DELETE FROM mtl_item_revisions_b

2197: END IF;
2198:
2199: --dbms_output.put_line('DELETE FROM mtl_item_revisions; x_return_status = ' || x_return_status);
2200:
2201: DELETE FROM mtl_item_revisions_b
2202: WHERE
2203: inventory_item_id = p_inventory_item_id
2204: AND organization_id = p_organization_id
2205: AND revision = p_revision

Line 2550: from mtl_item_revisions_b

2546: /* Added for PIM for Telco enhancements */
2547: begin
2548: select 1
2549: into l_inherit
2550: from mtl_item_revisions_b
2551: where revision_id = p_revision_id
2552: and effectivity_date <> p_effectivity_date;
2553: exception
2554: when others then