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_INV_ITEM_CATALOG_PVT dependencies on MTL_PARAMETERS

Line 158: FROM MTL_PARAMETERS P1,

154: FROM mtl_item_revisions_b item_rev
155: WHERE inventory_item_id = cp_item_id
156: AND EXISTS
157: (SELECT P2.ORGANIZATION_ID
158: FROM MTL_PARAMETERS P1,
159: MTL_PARAMETERS P2
160: WHERE P1.ORGANIZATION_ID = cp_org_id
161: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
162: AND p2.organization_id = item_rev.organization_id

Line 159: MTL_PARAMETERS P2

155: WHERE inventory_item_id = cp_item_id
156: AND EXISTS
157: (SELECT P2.ORGANIZATION_ID
158: FROM MTL_PARAMETERS P1,
159: MTL_PARAMETERS P2
160: WHERE P1.ORGANIZATION_ID = cp_org_id
161: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
162: AND p2.organization_id = item_rev.organization_id
163: )

Line 331: FROM MTL_PARAMETERS P1,

327: FROM mtl_system_items_kfv item -- changed for Business Event Enh.
328: WHERE inventory_item_id = cp_item_id
329: AND EXISTS
330: (SELECT P2.ORGANIZATION_ID
331: FROM MTL_PARAMETERS P1,
332: MTL_PARAMETERS P2
333: WHERE P1.ORGANIZATION_ID = cp_org_id
334: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
335: AND P2.ORGANIZATION_ID = item.ORGANIZATION_ID

Line 332: MTL_PARAMETERS P2

328: WHERE inventory_item_id = cp_item_id
329: AND EXISTS
330: (SELECT P2.ORGANIZATION_ID
331: FROM MTL_PARAMETERS P1,
332: MTL_PARAMETERS P2
333: WHERE P1.ORGANIZATION_ID = cp_org_id
334: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
335: AND P2.ORGANIZATION_ID = item.ORGANIZATION_ID
336: );

Line 372: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

368: l_curr_cc_id NUMBER;
369: l_curr_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;
370: --Start 4105841
371: l_event_ret_status VARCHAR2(1);
372: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
373: l_raise_event VARCHAR2(1);
374: --Start 4105841
375: l_item_description VARCHAR2(2000); --R12
376: l_item_number VARCHAR2(2000); --R12

Line 593: FROM MTL_PARAMETERS

589: IF l_raise_event = 'Y'
590: AND NVL(l_curr_cc_id,-1) = NVL(p_new_catalog_category_id,-1)
591: THEN
592: SELECT ORGANIZATION_CODE INTO l_org_code
593: FROM MTL_PARAMETERS
594: WHERE ORGANIZATION_ID = p_organization_id;
595: EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event(
596: p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT
597: ,p_Organization_Id => p_Organization_Id

Line 702: FROM mtl_parameters

698: FOR UPDATE OF lifecycle_id,current_phase_id;
699:
700: CURSOR c_get_master_org_details (cp_org_id IN NUMBER) IS
701: SELECT organization_id
702: FROM mtl_parameters
703: WHERE organization_id = master_organization_id
704: and organization_id = NVL(cp_org_id, organization_id);
705:
706: /* Bug: 3007563

Line 732: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

728: l_api_name VARCHAR2(30);
729: --Start 4105841
730: l_msg_data VARCHAR2(4000);
731: l_event_ret_status VARCHAR2(1);
732: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
733: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
734: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
735: -- End 4105841
736: BEGIN

Line 873: FROM MTL_PARAMETERS

869:
870: --Start 4105841 Raise the event for the organizations to which item is assigned.
871: --Raise only for the master item
872: SELECT ORGANIZATION_CODE INTO l_org_code
873: FROM MTL_PARAMETERS
874: WHERE ORGANIZATION_ID = p_organization_id;
875: --Added for Bug 4586769
876: SELECT CONCATENATED_SEGMENTS, DESCRIPTION
877: INTO l_item_number, l_item_desc

Line 1300: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

1296: FROM ego_item_projects item_proj
1297: WHERE inventory_item_id = cp_item_id
1298: AND EXISTS
1299: (SELECT P2.ORGANIZATION_ID
1300: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2
1301: WHERE P1.ORGANIZATION_ID = cp_org_id
1302: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
1303: AND P2.ORGANIZATION_ID = item_proj.organization_id
1304: )

Line 1319: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

1315: FROM ego_item_projects rev_proj
1316: WHERE inventory_item_id = cp_item_id
1317: AND EXISTS
1318: (SELECT P2.ORGANIZATION_ID
1319: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2
1320: WHERE P1.ORGANIZATION_ID = cp_org_id
1321: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
1322: AND P2.ORGANIZATION_ID = rev_proj.organization_id
1323: )

Line 1343: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

1339: FROM mtl_pending_item_status mpis
1340: WHERE inventory_item_id = cp_item_id
1341: AND EXISTS
1342: (SELECT P2.ORGANIZATION_ID
1343: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2
1344: WHERE P1.ORGANIZATION_ID = cp_org_id
1345: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
1346: AND P2.ORGANIZATION_ID = mpis.organization_id
1347: )

Line 1520: FROM mtl_parameters p1, mtl_parameters p2

1516: -- AND revision IS NULL
1517: AND revision_id IS NULL
1518: AND EXISTS
1519: (SELECT 'X'
1520: FROM mtl_parameters p1, mtl_parameters p2
1521: WHERE p1.organization_id = p_organization_id
1522: AND p1.master_organization_id = p2.master_organization_id
1523: AND p2.organization_id = proj.organization_id
1524: )

Line 1678: FROM mtl_parameters p1, mtl_parameters p2

1674: FROM mtl_item_revisions_b item_rev
1675: WHERE item_rev.inventory_item_id = cp_item_id
1676: AND EXISTS
1677: (SELECT 'X'
1678: FROM mtl_parameters p1, mtl_parameters p2
1679: WHERE p1.organization_id = cp_org_id
1680: AND p1.master_organization_id = p2.master_organization_id
1681: AND p2.organization_id = item_rev.organization_id
1682: )

Line 1846: ' (SELECT ''X'' FROM mtl_parameters p1, mtl_parameters p2 ' ||

1842: 'WHERE revised_item_id = :1' ||
1843: 'AND change_notice <> :2'||
1844: 'AND revised_item_sequence_id <> :3' ||
1845: 'AND EXISTS ' ||
1846: ' (SELECT ''X'' FROM mtl_parameters p1, mtl_parameters p2 ' ||
1847: ' WHERE p1.organization_id = :4 ' ||
1848: ' AND p1.master_organization_id = p2.master_organization_id ' ||
1849: ' AND p2.organization_id = change.organization_id )' ||
1850: ' AND status_type NOT IN (5,6) ' ||

Line 1922: ' (SELECT ''X'' FROM mtl_parameters p1, mtl_parameters p2 ' ||

1918: ' WHERE change.revised_item_id = :1 ' ||
1919: ' AND change.change_notice <> :2 ' ||
1920: ' AND change.revised_item_sequence_id <> :3 ' ||
1921: ' AND EXISTS ' ||
1922: ' (SELECT ''X'' FROM mtl_parameters p1, mtl_parameters p2 ' ||
1923: ' WHERE p1.organization_id = :4 ' ||
1924: ' AND p1.master_organization_id = p2.master_organization_id ' ||
1925: ' AND p2.organization_id = change.organization_id ' ||
1926: ' ) ' ||