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 911: UPDATE MTL_PENDING_ITEM_STATUS

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

Line 1060: l_revision_id mtl_pending_item_status.revision_id%TYPE;

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

Line 1061: l_phase_id mtl_pending_item_status.phase_id%TYPE;

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

Line 1062: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;

1058: l_sysdate DATE;
1059: l_revision mtl_item_revisions_b.revision%TYPE;
1060: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1061: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1062: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1063: l_status_code mtl_pending_item_status.status_code%TYPE;
1064: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1065: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1066: l_status_code_itm mtl_pending_item_status.status_code%TYPE;

Line 1063: l_status_code mtl_pending_item_status.status_code%TYPE;

1059: l_revision mtl_item_revisions_b.revision%TYPE;
1060: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1061: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1062: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1063: l_status_code mtl_pending_item_status.status_code%TYPE;
1064: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1065: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1066: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1067: l_status_code_def mtl_pending_item_status.status_code%TYPE;

Line 1064: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;

1060: l_revision_id mtl_pending_item_status.revision_id%TYPE;
1061: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1062: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1063: l_status_code mtl_pending_item_status.status_code%TYPE;
1064: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1065: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1066: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1067: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1068: l_pending_rec_count NUMBER;

Line 1065: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;

1061: l_phase_id mtl_pending_item_status.phase_id%TYPE;
1062: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1063: l_status_code mtl_pending_item_status.status_code%TYPE;
1064: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1065: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1066: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1067: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1068: l_pending_rec_count NUMBER;
1069: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

Line 1066: l_status_code_itm mtl_pending_item_status.status_code%TYPE;

1062: l_lifecycle_id mtl_pending_item_status.lifecycle_id%TYPE;
1063: l_status_code mtl_pending_item_status.status_code%TYPE;
1064: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1065: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1066: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1067: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1068: l_pending_rec_count NUMBER;
1069: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1070: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.NAME%TYPE;

Line 1067: l_status_code_def mtl_pending_item_status.status_code%TYPE;

1063: l_status_code mtl_pending_item_status.status_code%TYPE;
1064: l_phase_id_curr mtl_pending_item_status.phase_id%TYPE;
1065: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1066: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1067: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1068: l_pending_rec_count NUMBER;
1069: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1070: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.NAME%TYPE;
1071: l_dummy_char VARCHAR2(32767);

Line 1275: FROM mtl_pending_item_status

1271: --
1272: IF (NVL(l_phase_id_curr,-1) <> p_phase_id) THEN
1273: SELECT count(*)
1274: INTO l_pending_rec_count
1275: FROM mtl_pending_item_status
1276: WHERE inventory_item_id = p_inventory_item_id
1277: AND organization_id = p_organization_id
1278: AND pending_flag = 'Y'
1279: AND implemented_date IS NULL

Line 1356: INSERT INTO MTL_PENDING_ITEM_STATUS

1352: --
1353: -- to be removed after bug 3874132 is resoloved.
1354: --
1355: l_sysdate := SYSDATE;
1356: INSERT INTO MTL_PENDING_ITEM_STATUS
1357: (
1358: inventory_item_id
1359: ,organization_id
1360: ,status_code

Line 1550: UPDATE mtl_pending_item_status

1546: --
1547: -- to be removed after bug 3874132 is resoloved.
1548: --
1549: code_debug(l_api_name|| ' Updating pending change record ');
1550: UPDATE mtl_pending_item_status
1551: SET effective_date = p_new_effective_date,
1552: last_update_date = SYSDATE,
1553: last_updated_by = G_CURRENT_USER_ID,
1554: last_update_login = G_CURRENT_LOGIN_ID

Line 1579: DELETE mtl_pending_item_status

1575: --
1576: -- to be removed after bug 3874132 is resoloved.
1577: --
1578: code_debug(l_api_name|| ' Deleting pending change record ');
1579: DELETE mtl_pending_item_status
1580: WHERE inventory_item_id = p_inventory_item_id
1581: AND organization_id = p_organization_id
1582: AND NVL(revision_id,l_miss_num) = NVL(p_revision_id, l_miss_num)
1583: AND NVL(lifecycle_id, l_miss_num) = NVL(p_lifecycle_id, l_miss_num)

Line 1664: DELETE MTL_PENDING_ITEM_STATUS

1660: IF p_inventory_item_id IS NOT NULL THEN
1661: --
1662: -- change_id, change_line_id, inventory_item_id present
1663: --
1664: DELETE MTL_PENDING_ITEM_STATUS
1665: WHERE organization_id = p_organization_id
1666: AND inventory_item_id = p_inventory_item_id
1667: AND change_id = p_change_id
1668: AND change_line_id = p_change_line_id

Line 1675: DELETE MTL_PENDING_ITEM_STATUS

1671: ELSE
1672: --
1673: -- change_id, change_line_id present
1674: --
1675: DELETE MTL_PENDING_ITEM_STATUS
1676: WHERE organization_id = p_organization_id
1677: AND change_id = p_change_id
1678: AND change_line_id = p_change_line_id
1679: AND implemented_date IS NULL

Line 1687: DELETE MTL_PENDING_ITEM_STATUS

1683: IF p_inventory_item_id IS NOT NULL THEN
1684: --
1685: -- change_id, inventory_item_id present
1686: --
1687: DELETE MTL_PENDING_ITEM_STATUS
1688: WHERE organization_id = p_organization_id
1689: AND inventory_item_id = p_inventory_item_id
1690: AND change_id = p_change_id
1691: AND implemented_date IS NULL

Line 1697: DELETE MTL_PENDING_ITEM_STATUS

1693: ELSE
1694: --
1695: -- only change_id present
1696: --
1697: DELETE MTL_PENDING_ITEM_STATUS
1698: WHERE organization_id = p_organization_id
1699: AND change_id = p_change_id
1700: AND implemented_date IS NULL
1701: AND pending_flag = 'Y';

Line 1710: DELETE MTL_PENDING_ITEM_STATUS

1706: IF p_inventory_item_id IS NOT NULL THEN
1707: --
1708: -- change_line_id, inventory_item_id present
1709: --
1710: DELETE MTL_PENDING_ITEM_STATUS
1711: WHERE organization_id = p_organization_id
1712: AND inventory_item_id = p_inventory_item_id
1713: AND change_line_id = p_change_line_id
1714: AND implemented_date IS NULL

Line 1720: DELETE MTL_PENDING_ITEM_STATUS

1716: ELSE
1717: --
1718: -- only change_line_id present
1719: --
1720: DELETE MTL_PENDING_ITEM_STATUS
1721: WHERE organization_id = p_organization_id
1722: AND change_line_id = p_change_line_id
1723: AND implemented_date IS NULL
1724: AND pending_flag = 'Y';

Line 1732: DELETE MTL_PENDING_ITEM_STATUS

1728: --
1729: -- only inventory_item_id present
1730: -- delete where change_id and change_line_id are null
1731: --
1732: DELETE MTL_PENDING_ITEM_STATUS
1733: WHERE organization_id = p_organization_id
1734: AND inventory_item_id = p_inventory_item_id
1735: AND change_id IS NULL
1736: AND change_line_id IS NULL

Line 1834: FROM mtl_pending_item_status

1830:
1831: CURSOR c_get_pending_items (cp_change_id IN NUMBER
1832: ,cp_change_line_id IN NUMBER) IS
1833: SELECT *
1834: FROM mtl_pending_item_status
1835: WHERE implemented_date IS NULL
1836: AND pending_flag = 'Y'
1837: AND change_id = NVL(cp_change_id, change_id)
1838: AND change_line_id = NVL(cp_change_line_id, change_line_id);