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_SYSTEM_ITEMS_B

Line 111: l_organization_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

107: FROM eng_attachment_changes
108: WHERE revised_item_sequence_id = change.revised_item_sequence_id )
109: );
110:
111: l_organization_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
112: l_item_number VARCHAR2(999);
113: l_org_name VARCHAR2(999);
114: l_is_master_org VARCHAR2(100);
115: l_status_master_controlled VARCHAR2(100);

Line 245: l_curr_lc_id mtl_system_items_b.lifecycle_id%TYPE;

241: ,p_new_lc_id IN NUMBER
242: ,p_new_phase_id IN NUMBER
243: ,p_new_status_code IN VARCHAR2
244: ) RETURN VARCHAR2 IS
245: l_curr_lc_id mtl_system_items_b.lifecycle_id%TYPE;
246: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
247: l_curr_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
248: l_curr_phase_seq NUMBER;
249: l_new_lc_id mtl_system_items_b.lifecycle_id%TYPE;

Line 246: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;

242: ,p_new_phase_id IN NUMBER
243: ,p_new_status_code IN VARCHAR2
244: ) RETURN VARCHAR2 IS
245: l_curr_lc_id mtl_system_items_b.lifecycle_id%TYPE;
246: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
247: l_curr_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
248: l_curr_phase_seq NUMBER;
249: l_new_lc_id mtl_system_items_b.lifecycle_id%TYPE;
250: l_new_phase_id mtl_system_items_b.current_phase_id%TYPE;

Line 247: l_curr_status_code mtl_system_items_b.inventory_item_status_code%TYPE;

243: ,p_new_status_code IN VARCHAR2
244: ) RETURN VARCHAR2 IS
245: l_curr_lc_id mtl_system_items_b.lifecycle_id%TYPE;
246: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
247: l_curr_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
248: l_curr_phase_seq NUMBER;
249: l_new_lc_id mtl_system_items_b.lifecycle_id%TYPE;
250: l_new_phase_id mtl_system_items_b.current_phase_id%TYPE;
251: l_new_status_code mtl_system_items_b.inventory_item_status_code%TYPE;

Line 249: l_new_lc_id mtl_system_items_b.lifecycle_id%TYPE;

245: l_curr_lc_id mtl_system_items_b.lifecycle_id%TYPE;
246: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
247: l_curr_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
248: l_curr_phase_seq NUMBER;
249: l_new_lc_id mtl_system_items_b.lifecycle_id%TYPE;
250: l_new_phase_id mtl_system_items_b.current_phase_id%TYPE;
251: l_new_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
252: l_new_phase_seq NUMBER;
253:

Line 250: l_new_phase_id mtl_system_items_b.current_phase_id%TYPE;

246: l_curr_phase_id mtl_system_items_b.current_phase_id%TYPE;
247: l_curr_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
248: l_curr_phase_seq NUMBER;
249: l_new_lc_id mtl_system_items_b.lifecycle_id%TYPE;
250: l_new_phase_id mtl_system_items_b.current_phase_id%TYPE;
251: l_new_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
252: l_new_phase_seq NUMBER;
253:
254: -- data securiry functions supported

Line 251: l_new_status_code mtl_system_items_b.inventory_item_status_code%TYPE;

247: l_curr_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
248: l_curr_phase_seq NUMBER;
249: l_new_lc_id mtl_system_items_b.lifecycle_id%TYPE;
250: l_new_phase_id mtl_system_items_b.current_phase_id%TYPE;
251: l_new_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
252: l_new_phase_seq NUMBER;
253:
254: -- data securiry functions supported
255: l_fn_name_promote VARCHAR2(50);

Line 263: FROM mtl_system_items_b

259:
260: CURSOR c_get_item_det (cp_inventory_item_id IN NUMBER
261: ,cp_organization_id IN NUMBER) IS
262: SELECT lifecycle_id, current_phase_id, inventory_item_status_code
263: FROM mtl_system_items_b
264: WHERE inventory_item_id = cp_inventory_item_id
265: AND organization_id = cp_organization_id;
266:
267: CURSOR c_get_item_rev_det (cp_inventory_item_id IN NUMBER

Line 271: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

267: CURSOR c_get_item_rev_det (cp_inventory_item_id IN NUMBER
268: ,cp_organization_id IN NUMBER
269: ,cp_revision_id IN NUMBER) IS
270: SELECT rev.lifecycle_id, rev.current_phase_id, itm.inventory_item_status_code
271: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
272: WHERE itm.inventory_item_id = cp_inventory_item_id
273: AND itm.organization_id = cp_organization_id
274: AND rev.inventory_item_id = itm.inventory_item_id
275: AND rev.organization_id = rev.organization_id

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 458: l_old_status MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE%TYPE;

454:
455: l_event_return_status VARCHAR2(1);
456: l_phase_update VARCHAR2(1);
457: l_msg_data VARCHAR2(2000);
458: l_old_status MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE%TYPE;
459: l_new_status MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE%TYPE;
460: --End 4105841
461:
462: l_api_version NUMBER;

Line 459: l_new_status MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE%TYPE;

455: l_event_return_status VARCHAR2(1);
456: l_phase_update VARCHAR2(1);
457: l_msg_data VARCHAR2(2000);
458: l_old_status MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE%TYPE;
459: l_new_status MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE%TYPE;
460: --End 4105841
461:
462: l_api_version NUMBER;
463: l_api_name VARCHAR2(30);

Line 464: l_current_phase_id MTL_SYSTEM_ITEMS_B.CURRENT_PHASE_ID%TYPE;

460: --End 4105841
461:
462: l_api_version NUMBER;
463: l_api_name VARCHAR2(30);
464: l_current_phase_id MTL_SYSTEM_ITEMS_B.CURRENT_PHASE_ID%TYPE;
465: l_current_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
466: l_perform_policy_check BOOLEAN;
467: l_priv_name_to_check VARCHAR2(100);
468:

Line 641: UPDATE MTL_SYSTEM_ITEMS_B

637: ROLLBACK TO Implement_All_Pending_Changes;
638: END IF;
639: RETURN;
640: END IF;
641: UPDATE MTL_SYSTEM_ITEMS_B
642: SET CURRENT_PHASE_ID = NVL(l_phase_id.PHASE_ID,current_phase_id)
643: WHERE
644: INVENTORY_ITEM_ID = p_inventory_item_id
645: AND ORGANIZATION_ID IN

Line 710: UPDATE MTL_SYSTEM_ITEMS_B

706: END IF;
707: RETURN;
708: END IF;
709:
710: UPDATE MTL_SYSTEM_ITEMS_B
711: SET CURRENT_PHASE_ID = NVL(l_phase_id.PHASE_ID, current_phase_id)
712: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
713: AND ORGANIZATION_ID = p_organization_id;
714: l_phase_update := 'Y';

Line 723: FROM mtl_system_items_b msi

719: -- but only if we are at the master org or status is org controlled
720: --
721: ---Start 4105841 Business events
722: SELECT inventory_item_status_code INTO l_old_status
723: FROM mtl_system_items_b msi
724: WHERE msi.inventory_item_id = p_inventory_item_id
725: AND msi.organization_id = p_organization_id
726: AND rownum < 2;
727: ---End 4105841

Line 747: FROM mtl_system_items_b msi

743:
744:
745: ---Start 4105841 Business events
746: SELECT inventory_item_status_code INTO l_new_status
747: FROM mtl_system_items_b msi
748: WHERE msi.inventory_item_id = p_inventory_item_id
749: AND msi.organization_id = p_organization_id
750: AND rownum < 2;
751:

Line 1072: l_approval_status mtl_system_items_b.approval_status%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);
1072: l_approval_status mtl_system_items_b.approval_status%TYPE;
1073: l_priv_name_to_check VARCHAR2(100);
1074:
1075: l_revision_master_controlled VARCHAR2(1);
1076: l_status_master_controlled VARCHAR2(1);

Line 1084: FROM mtl_item_revisions_b rev, mtl_system_items_b item

1080: ,cp_org_id IN NUMBER
1081: ,cp_revision IN VARCHAR2
1082: ,cp_revision_id IN NUMBER) IS
1083: SELECT rev.current_phase_id, rev.lifecycle_id, rev.revision, rev.revision_id, item.approval_status
1084: FROM mtl_item_revisions_b rev, mtl_system_items_b item
1085: WHERE rev.inventory_item_id = cp_item_id
1086: AND rev.organization_id = cp_org_id
1087: AND rev.revision = NVL(cp_revision, rev.revision)
1088: AND rev.revision_id = NVL(cp_revision_id, rev.revision_id)

Line 1095: FROM mtl_system_items_b

1091:
1092: CURSOR c_get_item_details (cp_item_id IN NUMBER
1093: ,cp_org_id IN NUMBER) IS
1094: SELECT current_phase_id, lifecycle_id, inventory_item_status_code, approval_status
1095: FROM mtl_system_items_b
1096: WHERE inventory_item_id = cp_item_id
1097: AND organization_id = cp_org_id;
1098:
1099: CURSOR c_get_def_status_code (cp_phase_id IN NUMBER) IS

Line 1290: FROM mtl_system_items_b_kfv

1286: --
1287: IF p_item_number IS NULL THEN
1288: SELECT concatenated_segments
1289: INTO l_dummy_char
1290: FROM mtl_system_items_b_kfv
1291: WHERE inventory_item_id = p_inventory_item_id
1292: AND organization_id = p_organization_id;
1293: ELSE
1294: l_dummy_char := p_item_number;

Line 1938: , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE

1934: PROCEDURE Implement_Pending_Changes_CP
1935: (
1936: ERRBUF OUT NOCOPY VARCHAR2
1937: , RETCODE OUT NOCOPY NUMBER
1938: , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
1939: , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
1940: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
1941: )
1942: IS

Line 1939: , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE

1935: (
1936: ERRBUF OUT NOCOPY VARCHAR2
1937: , RETCODE OUT NOCOPY NUMBER
1938: , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
1939: , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
1940: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
1941: )
1942: IS
1943:

Line 1944: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

1940: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
1941: )
1942: IS
1943:
1944: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
1945: TYPE ITEM_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
1946: TYPE REV_TABLE IS TABLE OF MTL_ITEM_REVISIONS_B.REVISION%TYPE;
1947:
1948: l_revision_master_controlled VARCHAR2(1);

Line 1945: TYPE ITEM_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;

1941: )
1942: IS
1943:
1944: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
1945: TYPE ITEM_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
1946: TYPE REV_TABLE IS TABLE OF MTL_ITEM_REVISIONS_B.REVISION%TYPE;
1947:
1948: l_revision_master_controlled VARCHAR2(1);
1949: l_status_master_controlled VARCHAR2(1);

Line 2027: MTL_SYSTEM_ITEMS_B

2023:
2024: SELECT
2025: INVENTORY_ITEM_ID BULK COLLECT INTO l_items
2026: FROM
2027: MTL_SYSTEM_ITEMS_B
2028: WHERE
2029: ORGANIZATION_ID = l_orgs(org_index);
2030:
2031: ELSE