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 643: UPDATE MTL_SYSTEM_ITEMS_B

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

Line 712: UPDATE MTL_SYSTEM_ITEMS_B

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

Line 725: FROM mtl_system_items_b msi

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

Line 749: FROM mtl_system_items_b msi

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

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

Line 1087: FROM mtl_item_revisions_b rev, mtl_system_items_b item

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

Line 1098: FROM mtl_system_items_b

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

Line 1299: FROM mtl_system_items_b_kfv

1295: --
1296: IF p_item_number IS NULL THEN
1297: SELECT concatenated_segments
1298: INTO l_dummy_char
1299: FROM mtl_system_items_b_kfv
1300: WHERE inventory_item_id = p_inventory_item_id
1301: AND organization_id = p_organization_id;
1302: ELSE
1303: l_dummy_char := p_item_number;

Line 2005: , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE

2001: PROCEDURE Implement_Pending_Changes_CP
2002: (
2003: ERRBUF OUT NOCOPY VARCHAR2
2004: , RETCODE OUT NOCOPY NUMBER
2005: , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
2006: , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
2007: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
2008: )
2009: IS

Line 2006: , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE

2002: (
2003: ERRBUF OUT NOCOPY VARCHAR2
2004: , RETCODE OUT NOCOPY NUMBER
2005: , p_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
2006: , p_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
2007: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
2008: )
2009: IS
2010:

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

2007: , p_revision_code IN MTL_ITEM_REVISIONS_B.REVISION%TYPE
2008: )
2009: IS
2010:
2011: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
2012: TYPE ITEM_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
2013: TYPE REV_TABLE IS TABLE OF MTL_ITEM_REVISIONS_B.REVISION%TYPE;
2014:
2015: l_revision_master_controlled VARCHAR2(1);

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

2008: )
2009: IS
2010:
2011: TYPE ORG_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
2012: TYPE ITEM_TABLE IS TABLE OF MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
2013: TYPE REV_TABLE IS TABLE OF MTL_ITEM_REVISIONS_B.REVISION%TYPE;
2014:
2015: l_revision_master_controlled VARCHAR2(1);
2016: l_status_master_controlled VARCHAR2(1);

Line 2094: MTL_SYSTEM_ITEMS_B

2090:
2091: SELECT
2092: INVENTORY_ITEM_ID BULK COLLECT INTO l_items
2093: FROM
2094: MTL_SYSTEM_ITEMS_B
2095: WHERE
2096: ORGANIZATION_ID = l_orgs(org_index);
2097:
2098: ELSE