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.INVPAGI2 dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 79: FROM mtl_item_revisions_interface

75: ---Start: Bug fix 3051653
76: CURSOR c_get_revisions(cp_item_number VARCHAR2,cp_revision VARCHAR2,
77: cp_organization_id NUMBER) IS
78: SELECT organization_id,item_number
79: FROM mtl_item_revisions_interface
80: WHERE inventory_item_id IS NULL
81: AND item_number = cp_item_number
82: AND organization_id = cp_organization_id
83: AND revision = cp_revision

Line 665: update MTL_ITEM_REVISIONS_INTERFACE i

661: INVPUTLI.info('INVPAGI2: About to enter header cursorloop');
662: END IF;
663:
664:
665: update MTL_ITEM_REVISIONS_INTERFACE i
666: set i.organization_id = (select o.organization_id
667: from MTL_PARAMETERS o
668: where o.organization_code = i.organization_code)
669: where i.organization_id is NULL

Line 1903: update /+ index(MTL_ITEM_REVISIONS_INTERFACE, MTL_ITEM_REVS_INTERFACE_N2) / -- Bug 9678667 , adding hint suggested by perf team

1899: -- Store sysdate minus 1 sec when inserting default revision data
1900: l_curr_sysdate := sysdate - 1/86400;
1901:
1902: --default rev should be sysdate
1903: update /*+ index(MTL_ITEM_REVISIONS_INTERFACE, MTL_ITEM_REVS_INTERFACE_N2) */ -- Bug 9678667 , adding hint suggested by perf team
1904: mtl_item_revisions_interface
1905: set effectivity_date = sysdate
1906: where set_process_id = xset_id
1907: and process_flag = 1

Line 1904: mtl_item_revisions_interface

1900: l_curr_sysdate := sysdate - 1/86400;
1901:
1902: --default rev should be sysdate
1903: update /*+ index(MTL_ITEM_REVISIONS_INTERFACE, MTL_ITEM_REVS_INTERFACE_N2) */ -- Bug 9678667 , adding hint suggested by perf team
1904: mtl_item_revisions_interface
1905: set effectivity_date = sysdate
1906: where set_process_id = xset_id
1907: and process_flag = 1
1908: /* Bug 9678667 - Start */

Line 1931: update mtl_item_revisions_interface

1927: END IF;
1928:
1929:
1930: IF dumm_status = 0 THEN
1931: update mtl_item_revisions_interface
1932: set inventory_item_id = flex_id
1933: where item_number = c_revision_record.item_number
1934: and set_process_id = xset_id
1935: and organization_id = c_revision_record.organization_id

Line 1943: update mtl_item_revisions_interface

1939: --2885843:Effectivity date to sysdate if passed date is > sysdate
1940: IF (l_effectivity_date IS NULL
1941: OR TRUNC(l_effectivity_date) > TRUNC(SYSDATE)) THEN
1942:
1943: update mtl_item_revisions_interface
1944: set effectivity_date = sysdate
1945: where rowid = l_rowid;
1946:
1947: END IF;

Line 1954: FROM mtl_item_revisions_interface

1950:
1951: --End 2861248 :Populate Item Id for default revision only
1952:
1953: SELECT /*+ use_concat */ count(*) INTO revs -- Bug 9678667 : Adding hint suggested by perf team
1954: FROM mtl_item_revisions_interface
1955: WHERE ((organization_id = cr.organization_id
1956: AND inventory_item_id = cr.inventory_item_id)
1957: OR (organization_id = cr.organization_id
1958: AND item_number = cr.item_number)

Line 1976: insert into mtl_item_revisions_interface

1972: if (revs = 0) then
1973: if (cr.revision = default_rev) then -- Bug 4539703 for default revision create entry with sysdate - 1 sec
1974: --Bug 4626774 added request_id in both inserts
1975: --Adding Source System Id and Source System Reference to ensure Sequence Generated Item Number propogation
1976: insert into mtl_item_revisions_interface
1977: (organization_id, inventory_item_id, revision,
1978: process_flag, transaction_type, set_process_id, implementation_date,
1979: effectivity_date, creation_date, last_update_date
1980: ,request_id, source_system_id, source_system_reference)

Line 1987: insert into mtl_item_revisions_interface

1983: l_curr_sysdate, l_curr_sysdate, l_curr_sysdate
1984: ,request_id, cr.source_system_id, cr.source_system_reference);
1985: else
1986: --Adding Source System Id and Source System Reference to ensure Sequence Generated Item Number propogation
1987: insert into mtl_item_revisions_interface
1988: (organization_id, inventory_item_id, revision,
1989: process_flag, transaction_type, set_process_id
1990: ,request_id, source_system_id, source_system_reference)
1991: values (cr.organization_id, cr.inventory_item_id, cr.revision,

Line 2004: from mtl_item_revisions_interface

2000: if (cr.revision <> default_rev) then
2001: revs := 0;
2002:
2003: select count(revision) into revs
2004: from mtl_item_revisions_interface
2005: where set_process_id = xset_id
2006: and revision = default_rev
2007: AND process_flag = 1--Bug No: 3344480
2008: and ((organization_id = cr.organization_id

Line 2023: insert into mtl_item_revisions_interface -- create a default revision with sysdate - 1 sec

2019: if (revs = 0) then
2020: -- bug 4539703
2021: --Bug 4626774 added request_id in the insert
2022: --Adding Source System Id and Source System Reference to ensure Sequence Generated Item Number propogation
2023: insert into mtl_item_revisions_interface -- create a default revision with sysdate - 1 sec
2024: (organization_id, inventory_item_id, revision,
2025: process_flag, transaction_type, set_process_id,implementation_date,
2026: effectivity_date,creation_date,last_update_date
2027: ,request_id, source_system_id, source_system_reference)