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_ICC_STRUCTURE_PVT dependencies on MTL_ITEM_REVISIONS

Line 1453: from mtl_item_revisions_b b

1449: select revision_id,
1450: revision,
1451: effectivity_date,
1452: (select nvl( min(b.effectivity_date)-(1/86400),to_date('9999/12/31 00:00:00',date_fmt)) end_date
1453: from mtl_item_revisions_b b
1454: where b.inventory_item_id = a.inventory_item_id
1455: and b.organization_id = a.organization_id
1456: and b.effectivity_date > a.effectivity_date) end_date
1457: from mtl_item_revisions_b a

Line 1457: from mtl_item_revisions_b a

1453: from mtl_item_revisions_b b
1454: where b.inventory_item_id = a.inventory_item_id
1455: and b.organization_id = a.organization_id
1456: and b.effectivity_date > a.effectivity_date) end_date
1457: from mtl_item_revisions_b a
1458: where inventory_item_id = p_inventory_item_id
1459: and organization_id = p_organization_id
1460: order by effectivity_date;
1461: Begin

Line 1526: FROM mtl_item_revisions_b WHERE revision_id = FROM_OBJECT_REVISION_ID)

1522: AND ((P_obj_type IS NOT NULL AND
1523: P_fromMinorRevisionId BETWEEN nvl(from_minor_revision_id,P_fromMinorRevisionId) AND nvl(to_minor_revision_id,P_fromMinorRevisionId))
1524: OR (P_obj_type IS NULL AND P_toMinorRevCode IS NULL OR
1525: P_toMinorRevCode >= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(nvl(from_minor_revision_id,0)))
1526: FROM mtl_item_revisions_b WHERE revision_id = FROM_OBJECT_REVISION_ID)
1527: AND (to_object_revision_id IS NULL OR
1528: P_fromMinorRevCode <= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(nvl(to_minor_revision_id,9999999999999999)))
1529: FROM mtl_item_revisions_b WHERE revision_id = TO_OBJECT_REVISION_ID))))
1530: AND (change_notice is not null

Line 1529: FROM mtl_item_revisions_b WHERE revision_id = TO_OBJECT_REVISION_ID))))

1525: P_toMinorRevCode >= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(nvl(from_minor_revision_id,0)))
1526: FROM mtl_item_revisions_b WHERE revision_id = FROM_OBJECT_REVISION_ID)
1527: AND (to_object_revision_id IS NULL OR
1528: P_fromMinorRevCode <= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(nvl(to_minor_revision_id,9999999999999999)))
1529: FROM mtl_item_revisions_b WHERE revision_id = TO_OBJECT_REVISION_ID))))
1530: AND (change_notice is not null
1531: and( implementation_date is not null and P_changeNotice is null OR
1532: (implementation_date is null and change_notice = P_changeNotice
1533: AND EXISTS( SELECT 1 from eng_revised_items eri

Line 1537: AND (( EXISTS (SELECT null FROM mtl_item_revisions_b

1533: AND EXISTS( SELECT 1 from eng_revised_items eri
1534: where eri.revised_item_sequence_id = bic.revised_item_sequence_id
1535: and eri.bill_Sequence_id = bic.bill_Sequence_id )))
1536: OR (change_notice is null and P_changeNotice is null))
1537: AND (( EXISTS (SELECT null FROM mtl_item_revisions_b
1538: WHERE inventory_item_id = P_endItemId AND organization_id = P_endItemOrgId
1539: AND revision_id = from_end_item_rev_id)
1540: AND ( P_toEndItemMinorRevCode IS NULL OR P_toEndItemMinorRevCode >= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(from_end_item_minor_rev_id))
1541: FROM mtl_item_revisions_b WHERE revision_id = from_end_item_rev_id))

Line 1541: FROM mtl_item_revisions_b WHERE revision_id = from_end_item_rev_id))

1537: AND (( EXISTS (SELECT null FROM mtl_item_revisions_b
1538: WHERE inventory_item_id = P_endItemId AND organization_id = P_endItemOrgId
1539: AND revision_id = from_end_item_rev_id)
1540: AND ( P_toEndItemMinorRevCode IS NULL OR P_toEndItemMinorRevCode >= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(from_end_item_minor_rev_id))
1541: FROM mtl_item_revisions_b WHERE revision_id = from_end_item_rev_id))
1542: AND ( to_end_item_rev_id IS NULL OR P_fromEndItemMinorRevCode <= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(nvl(to_end_item_minor_rev_id,9999999999999999)))
1543: FROM mtl_item_revisions_b WHERE revision_id = to_end_item_rev_id))));
1544:
1545: begin

Line 1543: FROM mtl_item_revisions_b WHERE revision_id = to_end_item_rev_id))));

1539: AND revision_id = from_end_item_rev_id)
1540: AND ( P_toEndItemMinorRevCode IS NULL OR P_toEndItemMinorRevCode >= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(from_end_item_minor_rev_id))
1541: FROM mtl_item_revisions_b WHERE revision_id = from_end_item_rev_id))
1542: AND ( to_end_item_rev_id IS NULL OR P_fromEndItemMinorRevCode <= (SELECT concat(to_char(effectivity_date,'yyyymmddhh24miss'),to_char(nvl(to_end_item_minor_rev_id,9999999999999999)))
1543: FROM mtl_item_revisions_b WHERE revision_id = to_end_item_rev_id))));
1544:
1545: begin
1546:
1547: for comp in components loop

Line 1564: FROM mtl_item_revisions_b

1560: organization_id
1561: into fromEndItemMinorRevCode,
1562: endItemId,
1563: endItemOrgId
1564: FROM mtl_item_revisions_b
1565: WHERE revision_id = comp.FROM_END_ITEM_REV_ID;
1566: end if;
1567:
1568: if comp.TO_END_ITEM_REV_ID is not null then

Line 1575: FROM mtl_item_revisions_b

1571: organization_id
1572: into toEndItemMinorRevCode,
1573: endItemId,
1574: endItemOrgId
1575: FROM mtl_item_revisions_b
1576: WHERE revision_id = comp.TO_END_ITEM_REV_ID;
1577: end if;
1578:
1579: if fromEndItemMinorRevCode is not null then

Line 1586: FROM mtl_item_revisions_b

1582: organization_id
1583: into fromMinorRevCode,
1584: endItemId,
1585: endItemOrgId
1586: FROM mtl_item_revisions_b
1587: WHERE revision_id = comp.FROM_OBJECT_REVISION_ID;
1588: end if;
1589:
1590: if toMinorRevCode is not null then

Line 1597: FROM mtl_item_revisions_b

1593: organization_id
1594: into toMinorRevCode,
1595: endItemId,
1596: endItemOrgId
1597: FROM mtl_item_revisions_b
1598: WHERE revision_id = comp.TO_OBJECT_REVISION_ID;
1599: end if;
1600:
1601: open overlap(comp.component_sequence_id,

Line 1627: from mtl_item_revisions where inventory_item_id = G_INV_ITEM_ID

1623: and organization_id = comp.pk2_value;
1624:
1625: /* UT Fix: Modified query to use ass_item_id instead of comp_item_id. */
1626: select revision_label into G_EFF_FROM
1627: from mtl_item_revisions where inventory_item_id = G_INV_ITEM_ID
1628: and organization_id = comp.pk2_value and revision_id = comp.FROM_END_ITEM_REV_ID;
1629:
1630: exception
1631: when others then

Line 2957: from mtl_item_revisions_b

2953: l_bill_seq_id Number;
2954:
2955: cursor item_revisions is
2956: select effectivity_date
2957: from mtl_item_revisions_b
2958: where inventory_item_id = p_inv_item_id
2959: and organization_id = p_organization_id;
2960:
2961: BEGIN