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_ITEM_LC_IMP_PC_PUB dependencies on MTL_PENDING_ITEM_STATUS

Line 382: MTL_PENDING_ITEM_STATUS

378: ,lifecycle_id
379: ,status_code
380: ,effective_date
381: FROM
382: MTL_PENDING_ITEM_STATUS
383: WHERE inventory_item_id = p_inventory_item_id
384: AND organization_id = p_organization_id
385: AND revision_id = p_revision_id
386: AND pending_flag = 'Y'

Line 396: FROM MTL_PENDING_ITEM_STATUS

392: FOR UPDATE OF IMPLEMENTED_DATE, PENDING_FLAG;
393:
394: CURSOR l_phase_ids IS
395: SELECT lifecycle_id, phase_id, status_code
396: FROM MTL_PENDING_ITEM_STATUS
397: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
398: AND ORGANIZATION_ID = p_organization_id
399: AND REVISION_ID IS NULL
400: AND PENDING_FLAG = 'Y'

Line 410: FROM MTL_PENDING_ITEM_STATUS pending_status, mtl_system_items_b item

406: ORDER BY EFFECTIVE_DATE, LAST_UPDATE_DATE, ROWID;
407:
408: CURSOR c_item_pending_phase_change IS
409: SELECT pending_status.phase_id
410: FROM MTL_PENDING_ITEM_STATUS pending_status, mtl_system_items_b item
411: WHERE pending_status.INVENTORY_ITEM_ID = p_inventory_item_id
412: AND pending_status.ORGANIZATION_ID = p_organization_id
413: AND pending_status.PENDING_FLAG = 'Y'
414: AND pending_status.IMPLEMENTED_DATE IS NULL

Line 426: FROM MTL_PENDING_ITEM_STATUS pending_status, mtl_item_revisions_b rev

422:
423: -- bug 3833932
424: CURSOR c_rev_pending_phase_change IS
425: SELECT pending_status.phase_id
426: FROM MTL_PENDING_ITEM_STATUS pending_status, mtl_item_revisions_b rev
427: WHERE pending_status.INVENTORY_ITEM_ID = p_inventory_item_id
428: AND pending_status.ORGANIZATION_ID = p_organization_id
429: AND pending_status.PENDING_FLAG = 'Y'
430: AND pending_status.IMPLEMENTED_DATE IS NULL

Line 913: UPDATE MTL_PENDING_ITEM_STATUS

909: IF (FND_API.TO_BOOLEAN(p_is_master_org)
910: OR
911: FND_API.TO_BOOLEAN(p_revision_master_controlled) = FALSE
912: ) THEN
913: UPDATE MTL_PENDING_ITEM_STATUS
914: SET
915: PENDING_FLAG = 'N'
916: ,IMPLEMENTED_DATE = SYSDATE
917: WHERE CURRENT OF l_pending_revision_statuses;

Line 1062: l_revision_id mtl_pending_item_status.revision_id%TYPE;

1058: l_api_version NUMBER;
1059: l_api_name VARCHAR2(50);
1060: l_sysdate DATE;
1061: l_revision mtl_item_revisions_b.revision%TYPE;
1062: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1063: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1064: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1065: l_status_code mtl_pending_item_status.status_code%TYPE;
1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;

Line 1063: l_phase_id mtl_pending_item_status.phase_id%TYPE;

1059: l_api_name VARCHAR2(50);
1060: l_sysdate DATE;
1061: l_revision mtl_item_revisions_b.revision%TYPE;
1062: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1063: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1064: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1065: l_status_code mtl_pending_item_status.status_code%TYPE;
1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356

Line 1064: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;

1060: l_sysdate DATE;
1061: l_revision mtl_item_revisions_b.revision%TYPE;
1062: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1063: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1064: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1065: l_status_code mtl_pending_item_status.status_code%TYPE;
1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356
1068: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;

Line 1065: l_status_code mtl_pending_item_status.status_code%TYPE;

1061: l_revision mtl_item_revisions_b.revision%TYPE;
1062: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1063: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1064: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1065: l_status_code mtl_pending_item_status.status_code%TYPE;
1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356
1068: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1069: l_status_code_itm mtl_pending_item_status.status_code%TYPE;

Line 1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;

1062: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1063: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1064: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1065: l_status_code mtl_pending_item_status.status_code%TYPE;
1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356
1068: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1069: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1070: l_status_code_def mtl_pending_item_status.status_code%TYPE;

Line 1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356

1063: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1064: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1065: l_status_code mtl_pending_item_status.status_code%TYPE;
1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356
1068: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1069: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1070: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1071: l_pending_rec_count NUMBER;

Line 1068: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;

1064: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1065: l_status_code mtl_pending_item_status.status_code%TYPE;
1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356
1068: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1069: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1070: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1071: l_pending_rec_count NUMBER;
1072: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

Line 1069: l_status_code_itm mtl_pending_item_status.status_code%TYPE;

1065: l_status_code mtl_pending_item_status.status_code%TYPE;
1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356
1068: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1069: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1070: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1071: l_pending_rec_count NUMBER;
1072: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1073: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.NAME%TYPE;

Line 1070: l_status_code_def mtl_pending_item_status.status_code%TYPE;

1066: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1067: phase_id mtl_pending_item_status.phase_id%TYPE; -- Bug 14076356
1068: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1069: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1070: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1071: l_pending_rec_count NUMBER;
1072: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1073: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.NAME%TYPE;
1074: l_dummy_char VARCHAR2(32767);

Line 1284: FROM mtl_pending_item_status

1280: --
1281: IF (NVL(l_phase_id_curr,-1) <> p_phase_id) THEN
1282: SELECT count(*)
1283: INTO l_pending_rec_count
1284: FROM mtl_pending_item_status
1285: WHERE inventory_item_id = p_inventory_item_id
1286: AND organization_id = p_organization_id
1287: AND pending_flag = 'Y'
1288: AND implemented_date IS NULL

Line 1418: INSERT INTO MTL_PENDING_ITEM_STATUS

1414: --
1415: -- to be removed after bug 3874132 is resoloved.
1416: --
1417: l_sysdate := SYSDATE;
1418: INSERT INTO MTL_PENDING_ITEM_STATUS
1419: (
1420: inventory_item_id
1421: ,organization_id
1422: ,status_code

Line 1612: UPDATE mtl_pending_item_status

1608: --
1609: -- to be removed after bug 3874132 is resoloved.
1610: --
1611: code_debug(l_api_name|| ' Updating pending change record ');
1612: UPDATE mtl_pending_item_status
1613: SET effective_date = p_new_effective_date,
1614: last_update_date = SYSDATE,
1615: last_updated_by = G_CURRENT_USER_ID,
1616: last_update_login = G_CURRENT_LOGIN_ID

Line 1641: DELETE mtl_pending_item_status

1637: --
1638: -- to be removed after bug 3874132 is resoloved.
1639: --
1640: code_debug(l_api_name|| ' Deleting pending change record ');
1641: DELETE mtl_pending_item_status
1642: WHERE inventory_item_id = p_inventory_item_id
1643: AND organization_id = p_organization_id
1644: AND NVL(revision_id,l_miss_num) = NVL(p_revision_id, l_miss_num)
1645: AND NVL(lifecycle_id, l_miss_num) = NVL(p_lifecycle_id, l_miss_num)

Line 1726: DELETE MTL_PENDING_ITEM_STATUS

1722: IF p_inventory_item_id IS NOT NULL THEN
1723: --
1724: -- change_id, change_line_id, inventory_item_id present
1725: --
1726: DELETE MTL_PENDING_ITEM_STATUS
1727: WHERE organization_id = p_organization_id
1728: AND inventory_item_id = p_inventory_item_id
1729: AND change_id = p_change_id
1730: AND change_line_id = p_change_line_id

Line 1737: DELETE MTL_PENDING_ITEM_STATUS

1733: ELSE
1734: --
1735: -- change_id, change_line_id present
1736: --
1737: DELETE MTL_PENDING_ITEM_STATUS
1738: WHERE organization_id = p_organization_id
1739: AND change_id = p_change_id
1740: AND change_line_id = p_change_line_id
1741: AND implemented_date IS NULL

Line 1749: DELETE MTL_PENDING_ITEM_STATUS

1745: IF p_inventory_item_id IS NOT NULL THEN
1746: --
1747: -- change_id, inventory_item_id present
1748: --
1749: DELETE MTL_PENDING_ITEM_STATUS
1750: WHERE organization_id = p_organization_id
1751: AND inventory_item_id = p_inventory_item_id
1752: AND change_id = p_change_id
1753: AND implemented_date IS NULL

Line 1759: DELETE MTL_PENDING_ITEM_STATUS

1755: ELSE
1756: --
1757: -- only change_id present
1758: --
1759: DELETE MTL_PENDING_ITEM_STATUS
1760: WHERE organization_id = p_organization_id
1761: AND change_id = p_change_id
1762: AND implemented_date IS NULL
1763: AND pending_flag = 'Y';

Line 1772: DELETE MTL_PENDING_ITEM_STATUS

1768: IF p_inventory_item_id IS NOT NULL THEN
1769: --
1770: -- change_line_id, inventory_item_id present
1771: --
1772: DELETE MTL_PENDING_ITEM_STATUS
1773: WHERE organization_id = p_organization_id
1774: AND inventory_item_id = p_inventory_item_id
1775: AND change_line_id = p_change_line_id
1776: AND implemented_date IS NULL

Line 1782: DELETE MTL_PENDING_ITEM_STATUS

1778: ELSE
1779: --
1780: -- only change_line_id present
1781: --
1782: DELETE MTL_PENDING_ITEM_STATUS
1783: WHERE organization_id = p_organization_id
1784: AND change_line_id = p_change_line_id
1785: AND implemented_date IS NULL
1786: AND pending_flag = 'Y';

Line 1794: DELETE MTL_PENDING_ITEM_STATUS

1790: --
1791: -- only inventory_item_id present
1792: -- delete where change_id and change_line_id are null
1793: --
1794: DELETE MTL_PENDING_ITEM_STATUS
1795: WHERE organization_id = p_organization_id
1796: AND inventory_item_id = p_inventory_item_id
1797: AND change_id IS NULL
1798: AND change_line_id IS NULL

Line 1901: FROM mtl_pending_item_status

1897:
1898: CURSOR c_get_pending_items (cp_change_id IN NUMBER
1899: ,cp_change_line_id IN NUMBER) IS
1900: SELECT *
1901: FROM mtl_pending_item_status
1902: WHERE implemented_date IS NULL
1903: AND pending_flag = 'Y'
1904: AND change_id = NVL(cp_change_id, change_id)
1905: AND change_line_id = NVL(cp_change_line_id, change_line_id);