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

Line 195: FROM mtl_parameters mp

191: /* Do not convert name to ids, which is required only for error reporting.
192: -- Convert the master org values. Convert Organization Id to Organization Code
193: UPDATE ego_item_associations_intf eiai
194: SET organization_code = ( SELECT mp.organization_code
195: FROM mtl_parameters mp
196: WHERE mp.organization_id = eiai.organization_id
197: AND mp.master_organization_id = mp.organization_id)
198: WHERE eiai.batch_id = p_batch_id
199: AND ( eiai.data_level_id = G_ITEM_SUPPLIER_LEVEL OR eiai.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL )

Line 207: FROM mtl_parameters mp

203:
204: -- Convert the org values. Convert Organization Id to Organization Code
205: UPDATE ego_item_associations_intf eiai
206: SET organization_code = ( SELECT mp.organization_code
207: FROM mtl_parameters mp
208: WHERE mp.organization_id = eiai.organization_id)
209: WHERE eiai.batch_id = p_batch_id
210: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL
211: AND eiai.process_flag = G_REC_IN_PROCESS

Line 309: FROM mtl_parameters mp

305: AND ( eiai.organization_id IS NULL
306: OR NOT EXISTS
307: (
308: SELECT 1
309: FROM mtl_parameters mp
310: WHERE mp.master_organization_id = eiai.organization_id
311: )
312: );
313: UPDATE ego_item_associations_intf eiai

Line 322: FROM mtl_parameters mp

318: AND ( eiai.organization_id IS NULL
319: OR NOT EXISTS
320: (
321: SELECT 1
322: FROM mtl_parameters mp
323: WHERE mp.organization_id = eiai.organization_id
324: )
325: );
326: UPDATE ego_item_associations_intf eiai

Line 958: FROM ego_item_associations eia, mtl_parameters mp

954: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL
955: AND NOT EXISTS
956: (
957: SELECT 1
958: FROM ego_item_associations eia, mtl_parameters mp
959: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL
960: AND eia.inventory_item_id = eiai.inventory_item_id
961: AND eia.organization_id = mp.master_organization_id
962: AND mp.organization_id = eiai.organization_id

Line 968: FROM ego_item_associations_intf eiai2, mtl_parameters mp

964: AND eia.pk2_value = eiai.pk2_value
965: AND eia.status_code = G_ACTIVE
966: UNION ALL
967: SELECT 1
968: FROM ego_item_associations_intf eiai2, mtl_parameters mp
969: WHERE eiai2.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL
970: AND eiai2.inventory_item_id = eiai.inventory_item_id
971: AND eiai2.organization_id = mp.master_organization_id
972: AND mp.organization_id = eiai.organization_id

Line 988: FROM ego_item_associations eia, mtl_parameters mp

984: AND eiai.transaction_type = G_CREATE
985: AND NOT EXISTS
986: (
987: SELECT 1
988: FROM ego_item_associations eia, mtl_parameters mp
989: WHERE eia.inventory_item_id = eiai.inventory_item_id
990: AND eia.organization_id = mp.master_organization_id
991: AND mp.organization_id = eiai.organization_id
992: AND eia.data_level_id = G_ITEM_SUPPLIER_LEVEL

Line 997: FROM ego_item_associations_intf eiai1, mtl_parameters mp

993: AND eia.pk1_value = eiai.pk1_value
994: AND eia.pk2_value IS NULL
995: UNION ALL
996: SELECT 1
997: FROM ego_item_associations_intf eiai1, mtl_parameters mp
998: WHERE eiai1.inventory_item_id = eiai.inventory_item_id
999: AND eiai1.organization_id = mp.master_organization_id
1000: AND mp.organization_id = eiai.organization_id
1001: AND eiai1.data_level_id = G_ITEM_SUPPLIER_LEVEL

Line 1017: FROM ego_item_associations eia, mtl_parameters mp

1013: AND eiai.transaction_type = G_CREATE
1014: AND NOT EXISTS
1015: (
1016: SELECT 1
1017: FROM ego_item_associations eia, mtl_parameters mp
1018: WHERE eia.inventory_item_id = eiai.inventory_item_id
1019: AND eia.organization_id = mp.master_organization_id
1020: AND mp.organization_id = eiai.organization_id
1021: AND eia.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL

Line 1026: FROM ego_item_associations_intf eiai1, mtl_parameters mp

1022: AND eia.pk1_value = eiai.pk1_value
1023: AND eia.pk2_value = eiai.pk2_value
1024: UNION ALL
1025: SELECT 1
1026: FROM ego_item_associations_intf eiai1, mtl_parameters mp
1027: WHERE eiai1.inventory_item_id = eiai.inventory_item_id
1028: AND eiai1.organization_id = mp.master_organization_id
1029: AND mp.organization_id = eiai.organization_id
1030: AND eiai1.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL

Line 1081: FROM ego_item_associations_intf eiai, mtl_parameters mp

1077: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL
1078: AND EXISTS
1079: (
1080: SELECT 1
1081: FROM ego_item_associations_intf eiai, mtl_parameters mp
1082: WHERE eiai.inventory_item_id = eia.inventory_item_id
1083: AND eiai.batch_id = p_batch_id
1084: AND eiai.process_flag = G_REC_IN_PROCESS
1085: AND eiai.organization_id = mp.master_organization_id

Line 1099: FROM ego_item_associations_intf eiai, mtl_parameters mp

1095: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL
1096: AND EXISTS
1097: (
1098: SELECT 1
1099: FROM ego_item_associations_intf eiai, mtl_parameters mp
1100: WHERE eiai.inventory_item_id = eia.inventory_item_id
1101: AND eiai.batch_id = p_batch_id
1102: AND eiai.process_flag = G_REC_IN_PROCESS
1103: AND eiai.organization_id = mp.master_organization_id

Line 1115: FROM ego_item_associations_intf eiai, mtl_parameters mp

1111: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL
1112: AND EXISTS
1113: (
1114: SELECT 1
1115: FROM ego_item_associations_intf eiai, mtl_parameters mp
1116: WHERE eiai.association_id = eia.association_id
1117: AND eiai.batch_id = p_batch_id
1118: AND eiai.process_flag = G_REC_IN_PROCESS
1119: AND eiai.organization_id = mp.master_organization_id

Line 1131: FROM ego_item_associations_intf eiai, mtl_parameters mp

1127: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL
1128: AND EXISTS
1129: (
1130: SELECT 1
1131: FROM ego_item_associations_intf eiai, mtl_parameters mp
1132: WHERE eiai.inventory_item_id = eia.inventory_item_id
1133: AND eiai.batch_id = p_batch_id
1134: AND eiai.process_flag = G_REC_IN_PROCESS
1135: AND eiai.organization_id = mp.master_organization_id

Line 1315: FROM ego_item_associations_intf eiai, mtl_parameters mp

1311: ,G_USER_ID
1312: ,G_SYSDATE
1313: ,G_LOGIN_ID
1314: ,G_REQUEST_ID
1315: FROM ego_item_associations_intf eiai, mtl_parameters mp
1316: WHERE eiai.inventory_item_id = eia.inventory_item_id
1317: AND eiai.organization_id = mp.master_organization_id
1318: AND mp.organization_id = eia.organization_id
1319: AND eiai.data_level_id = G_ITEM_SUPPLIER_LEVEL

Line 1328: FROM ego_item_associations_intf eiai, mtl_parameters mp

1324: )
1325: WHERE EXISTS
1326: (
1327: SELECT 1
1328: FROM ego_item_associations_intf eiai, mtl_parameters mp
1329: WHERE eiai.inventory_item_id = eia.inventory_item_id
1330: AND eiai.organization_id = mp.master_organization_id
1331: AND eia.organization_id = mp.organization_id
1332: AND eiai.data_level_id = G_ITEM_SUPPLIER_LEVEL

Line 1348: FROM ego_item_associations_intf eiai, mtl_parameters mp

1344: ,G_USER_ID
1345: ,G_SYSDATE
1346: ,G_LOGIN_ID
1347: ,G_REQUEST_ID
1348: FROM ego_item_associations_intf eiai, mtl_parameters mp
1349: WHERE eiai.inventory_item_id = eia.inventory_item_id
1350: AND eiai.organization_id = mp.master_organization_id
1351: AND eia.organization_id = mp.organization_id
1352: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL

Line 1362: FROM ego_item_associations_intf eiai, mtl_parameters mp

1358: )
1359: WHERE EXISTS
1360: (
1361: SELECT 1
1362: FROM ego_item_associations_intf eiai, mtl_parameters mp
1363: WHERE eiai.inventory_item_id = eia.inventory_item_id
1364: AND eiai.organization_id = mp.master_organization_id
1365: AND mp.organization_id = eia.organization_id
1366: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL

Line 1637: FROM mtl_parameters mp

1633:
1634: -- Convert the master org values. Convert Organization Code to Organization Id
1635: UPDATE ego_item_associations_intf eiai
1636: SET organization_id = ( SELECT mp.organization_id
1637: FROM mtl_parameters mp
1638: WHERE mp.organization_code = eiai.organization_code
1639: AND mp.master_organization_id = mp.organization_id)
1640: WHERE eiai.batch_id = p_batch_id
1641: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)

Line 1649: FROM mtl_parameters mp

1645:
1646: -- Correct the organization id to master organization for double intersections
1647: UPDATE ego_item_associations_intf eiai
1648: SET organization_id = ( SELECT mp.master_organization_id
1649: FROM mtl_parameters mp
1650: WHERE mp.organization_id = eiai.organization_id)
1651: WHERE eiai.batch_id = p_batch_id
1652: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)
1653: AND ( eiai.data_level_id = G_ITEM_SUPPLIER_LEVEL OR eiai.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL );

Line 1658: FROM mtl_parameters mp

1654:
1655: -- Convert the master org values. Convert Organization Code to Organization Id
1656: UPDATE ego_item_associations_intf eiai
1657: SET organization_id = ( SELECT mp.organization_id
1658: FROM mtl_parameters mp
1659: WHERE mp.organization_code = eiai.organization_code)
1660: WHERE eiai.batch_id = p_batch_id
1661: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)
1662: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL

Line 1668: FROM mtl_parameters mp

1664: AND eiai.organization_code IS NOT NULL;
1665: -- Convert the organization id to code in order to throw the errors for rules
1666: UPDATE ego_item_associations_intf eiai
1667: SET organization_code = ( SELECT mp.organization_code
1668: FROM mtl_parameters mp
1669: WHERE mp.organization_id = eiai.organization_id
1670: )
1671: WHERE eiai.batch_id = p_batch_id
1672: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)

Line 2067: FROM mtl_parameters

2063: /*
2064: BEGIN
2065: SELECT master_organization_id
2066: INTO l_master_org_id
2067: FROM mtl_parameters
2068: WHERE organization_id = p_from_org_id;
2069: EXCEPTION
2070: WHEN NO_DATA_FOUND THEN
2071: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 2127: ,mtl_parameters mp

2123: ,msii.bundle_id
2124: ,G_REQUEST_ID
2125: FROM ego_item_associations eia
2126: ,mtl_system_items_interface msii
2127: ,mtl_parameters mp
2128: WHERE eia.inventory_item_id = p_src_item_id
2129: -- AND msii.organization_id = mp.organization_id Copy_Item_Id will be populated only for master org items
2130: --AND mp.organization_id = mp.master_organization_id Copy all triple intersections
2131: AND msii.set_process_id = p_batch_id

Line 2285: ,mtl_parameters mp

2281: ,G_REQUEST_ID
2282: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2283: FROM ego_item_associations eia
2284: ,mtl_system_items_interface msii
2285: ,mtl_parameters mp
2286: ,mtl_system_items_interface msii2
2287: WHERE eia.inventory_item_id = msii2.style_item_id
2288: AND msii.organization_id = mp.organization_id
2289: AND msii.set_process_id = p_batch_id

Line 2363: ,mtl_parameters mp

2359: ,G_REQUEST_ID
2360: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2361: FROM ego_item_associations eia
2362: ,mtl_system_items_interface msii
2363: ,mtl_parameters mp
2364: WHERE eia.inventory_item_id = msii.style_item_id
2365: AND msii.organization_id = mp.organization_id
2366: --AND mp.organization_id = mp.master_organization_id
2367: AND msii.set_process_id = p_batch_id

Line 2441: ,mtl_parameters mp

2437: ,G_REQUEST_ID
2438: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2439: FROM ego_item_associations_intf eiai1
2440: ,mtl_system_items_b_kfv msibk
2441: ,mtl_parameters mp
2442: WHERE eiai1.inventory_item_id = msibk.style_item_id
2443: AND eiai1.organization_id = msibk.organization_id
2444: AND msibk.organization_id = mp.organization_id
2445: -- AND mp.organization_id = mp.master_organization_id

Line 2680: mtl_parameters mp

2676: ,mtl_system_items_interface_s.NEXTVAL
2677: ,G_REQUEST_ID
2678: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2679: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk,
2680: mtl_parameters mp
2681: WHERE eiai.inventory_item_id = l_pack_rec.inventory_item_id
2682: AND eiai.organization_id = mp.organization_id
2683: --AND mp.master_organization_id = mp.organization_id
2684: AND eiai.batch_id = p_batch_id