APPS.ENG_ECO_UTIL dependencies on MTL_ITEM_REVISIONS_B

Line 1617: -- update rev item's new revision in MTL_ITEM_REVISIONS_B

1613: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1614: END IF ;
1615:
1616: -- Modified query for performance bug 4251776
1617: -- update rev item's new revision in MTL_ITEM_REVISIONS_B
1618: UPDATE MTL_ITEM_REVISIONS_B
1619: SET effectivity_date = p_effectivity_date,
1620: last_update_date = sysdate
1621: WHERE change_notice = x_change_notice

Line 1618: UPDATE MTL_ITEM_REVISIONS_B

1614: END IF ;
1615:
1616: -- Modified query for performance bug 4251776
1617: -- update rev item's new revision in MTL_ITEM_REVISIONS_B
1618: UPDATE MTL_ITEM_REVISIONS_B
1619: SET effectivity_date = p_effectivity_date,
1620: last_update_date = sysdate
1621: WHERE change_notice = x_change_notice
1622: AND organization_id = x_organization_id

Line 1783: l_max_smaller_eff_date mtl_item_revisions_b.effectivity_date%TYPE;

1779: -- bug 14548151
1780: l_organization_id eng_revised_items.organization_id%TYPE;
1781: l_revision eng_revised_items.new_item_revision%TYPE;
1782: l_item_id eng_revised_items.revised_item_id%TYPE;
1783: l_max_smaller_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1784: l_min_bigger_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1785: -- bug 14548151 end
1786:
1787: -- Status Lookups

Line 1784: l_min_bigger_eff_date mtl_item_revisions_b.effectivity_date%TYPE;

1780: l_organization_id eng_revised_items.organization_id%TYPE;
1781: l_revision eng_revised_items.new_item_revision%TYPE;
1782: l_item_id eng_revised_items.revised_item_id%TYPE;
1783: l_max_smaller_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1784: l_min_bigger_eff_date mtl_item_revisions_b.effectivity_date%TYPE;
1785: -- bug 14548151 end
1786:
1787: -- Status Lookups
1788: --CANCELLED CONSTANT NUMBER := 5;

Line 1862: FROM mtl_item_revisions_b

1858: FETCH c_item_revisions INTO l_organization_id, l_revision, l_item_id;
1859: WHILE c_item_revisions%FOUND
1860: LOOP
1861: SELECT max(effectivity_date) into l_max_smaller_eff_date
1862: FROM mtl_item_revisions_b
1863: WHERE inventory_item_id = l_item_id and revision < l_revision
1864: AND organization_id = l_organization_id;
1865:
1866: SELECT min(effectivity_date) into l_min_bigger_eff_date

Line 1867: FROM mtl_item_revisions_b

1863: WHERE inventory_item_id = l_item_id and revision < l_revision
1864: AND organization_id = l_organization_id;
1865:
1866: SELECT min(effectivity_date) into l_min_bigger_eff_date
1867: FROM mtl_item_revisions_b
1868: WHERE inventory_item_id = l_item_id and revision > l_revision
1869: AND organization_id = l_organization_id;
1870:
1871: IF p_effectivity_date <= l_max_smaller_eff_date OR p_effectivity_date >= l_min_bigger_eff_date THEN

Line 2008: UPDATE MTL_ITEM_REVISIONS_B

2004: END IF ;
2005:
2006: -- Modified query for performance bug 4251776
2007: -- update rev item's new revision in MTL_ITEM_REVISIONS _B
2008: UPDATE MTL_ITEM_REVISIONS_B
2009: SET effectivity_date = p_effectivity_date,
2010: last_update_date = sysdate
2011: WHERE change_notice = x_change_notice
2012: AND organization_id = x_organization_id

Line 2604: from MTL_ITEM_REVISIONS_B I

2600: -- Delete item revisions created by revised items on ECO
2601:
2602: delete from MTL_ITEM_REVISIONS_TL
2603: where revision_id in(select revision_id
2604: from MTL_ITEM_REVISIONS_B I
2605: WHERE CHANGE_NOTICE = change_order
2606: AND ORGANIZATION_ID = org_id
2607: AND IMPLEMENTATION_DATE IS NULL
2608: AND INVENTORY_ITEM_ID IN

Line 2617: DELETE FROM MTL_ITEM_REVISIONS_B I

2613: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
2614: AND R.CANCELLATION_DATE IS NOT NULL));
2615:
2616:
2617: DELETE FROM MTL_ITEM_REVISIONS_B I
2618: WHERE CHANGE_NOTICE = change_order
2619: AND ORGANIZATION_ID = org_id
2620: AND IMPLEMENTATION_DATE IS NULL
2621: AND INVENTORY_ITEM_ID IN (SELECT REVISED_ITEM_ID