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 898: FROM ego_item_associations eia, mtl_parameters mp

894: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL
895: AND NOT EXISTS
896: (
897: SELECT 1
898: FROM ego_item_associations eia, mtl_parameters mp
899: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL
900: AND eia.inventory_item_id = eiai.inventory_item_id
901: AND eia.organization_id = mp.master_organization_id
902: AND mp.organization_id = eiai.organization_id

Line 908: FROM ego_item_associations_intf eiai2, mtl_parameters mp

904: AND eia.pk2_value = eiai.pk2_value
905: AND eia.status_code = G_ACTIVE
906: UNION ALL
907: SELECT 1
908: FROM ego_item_associations_intf eiai2, mtl_parameters mp
909: WHERE eiai2.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL
910: AND eiai2.inventory_item_id = eiai.inventory_item_id
911: AND eiai2.organization_id = mp.master_organization_id
912: AND mp.organization_id = eiai.organization_id

Line 928: FROM ego_item_associations eia, mtl_parameters mp

924: AND eiai.transaction_type = G_CREATE
925: AND NOT EXISTS
926: (
927: SELECT 1
928: FROM ego_item_associations eia, mtl_parameters mp
929: WHERE eia.inventory_item_id = eiai.inventory_item_id
930: AND eia.organization_id = mp.master_organization_id
931: AND mp.organization_id = eiai.organization_id
932: AND eia.data_level_id = G_ITEM_SUPPLIER_LEVEL

Line 937: FROM ego_item_associations_intf eiai1, mtl_parameters mp

933: AND eia.pk1_value = eiai.pk1_value
934: AND eia.pk2_value IS NULL
935: UNION ALL
936: SELECT 1
937: FROM ego_item_associations_intf eiai1, mtl_parameters mp
938: WHERE eiai1.inventory_item_id = eiai.inventory_item_id
939: AND eiai1.organization_id = mp.master_organization_id
940: AND mp.organization_id = eiai.organization_id
941: AND eiai1.data_level_id = G_ITEM_SUPPLIER_LEVEL

Line 957: FROM ego_item_associations eia, mtl_parameters mp

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

Line 966: FROM ego_item_associations_intf eiai1, mtl_parameters mp

962: AND eia.pk1_value = eiai.pk1_value
963: AND eia.pk2_value = eiai.pk2_value
964: UNION ALL
965: SELECT 1
966: FROM ego_item_associations_intf eiai1, mtl_parameters mp
967: WHERE eiai1.inventory_item_id = eiai.inventory_item_id
968: AND eiai1.organization_id = mp.master_organization_id
969: AND mp.organization_id = eiai.organization_id
970: AND eiai1.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL

Line 1021: FROM ego_item_associations_intf eiai, mtl_parameters mp

1017: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL
1018: AND EXISTS
1019: (
1020: SELECT 1
1021: FROM ego_item_associations_intf eiai, mtl_parameters mp
1022: WHERE eiai.inventory_item_id = eia.inventory_item_id
1023: AND eiai.batch_id = p_batch_id
1024: AND eiai.process_flag = G_REC_IN_PROCESS
1025: AND eiai.organization_id = mp.master_organization_id

Line 1039: FROM ego_item_associations_intf eiai, mtl_parameters mp

1035: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL
1036: AND EXISTS
1037: (
1038: SELECT 1
1039: FROM ego_item_associations_intf eiai, mtl_parameters mp
1040: WHERE eiai.inventory_item_id = eia.inventory_item_id
1041: AND eiai.batch_id = p_batch_id
1042: AND eiai.process_flag = G_REC_IN_PROCESS
1043: AND eiai.organization_id = mp.master_organization_id

Line 1055: FROM ego_item_associations_intf eiai, mtl_parameters mp

1051: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL
1052: AND EXISTS
1053: (
1054: SELECT 1
1055: FROM ego_item_associations_intf eiai, mtl_parameters mp
1056: WHERE eiai.association_id = eia.association_id
1057: AND eiai.batch_id = p_batch_id
1058: AND eiai.process_flag = G_REC_IN_PROCESS
1059: AND eiai.organization_id = mp.master_organization_id

Line 1071: FROM ego_item_associations_intf eiai, mtl_parameters mp

1067: WHERE eia.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL
1068: AND EXISTS
1069: (
1070: SELECT 1
1071: FROM ego_item_associations_intf eiai, mtl_parameters mp
1072: WHERE eiai.inventory_item_id = eia.inventory_item_id
1073: AND eiai.batch_id = p_batch_id
1074: AND eiai.process_flag = G_REC_IN_PROCESS
1075: AND eiai.organization_id = mp.master_organization_id

Line 1254: FROM ego_item_associations_intf eiai, mtl_parameters mp

1250: ,G_USER_ID
1251: ,G_SYSDATE
1252: ,G_LOGIN_ID
1253: ,G_REQUEST_ID
1254: FROM ego_item_associations_intf eiai, mtl_parameters mp
1255: WHERE eiai.inventory_item_id = eia.inventory_item_id
1256: AND eiai.organization_id = mp.master_organization_id
1257: AND mp.organization_id = eia.organization_id
1258: AND eiai.data_level_id = G_ITEM_SUPPLIER_LEVEL

Line 1267: FROM ego_item_associations_intf eiai, mtl_parameters mp

1263: )
1264: WHERE EXISTS
1265: (
1266: SELECT 1
1267: FROM ego_item_associations_intf eiai, mtl_parameters mp
1268: WHERE eiai.inventory_item_id = eia.inventory_item_id
1269: AND eiai.organization_id = mp.master_organization_id
1270: AND eia.organization_id = mp.organization_id
1271: AND eiai.data_level_id = G_ITEM_SUPPLIER_LEVEL

Line 1285: FROM ego_item_associations_intf eiai, mtl_parameters mp

1281: ,G_USER_ID
1282: ,G_SYSDATE
1283: ,G_LOGIN_ID
1284: ,G_REQUEST_ID
1285: FROM ego_item_associations_intf eiai, mtl_parameters mp
1286: WHERE eiai.inventory_item_id = eia.inventory_item_id
1287: AND eiai.organization_id = mp.master_organization_id
1288: AND eia.organization_id = mp.organization_id
1289: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL

Line 1299: FROM ego_item_associations_intf eiai, mtl_parameters mp

1295: )
1296: WHERE EXISTS
1297: (
1298: SELECT 1
1299: FROM ego_item_associations_intf eiai, mtl_parameters mp
1300: WHERE eiai.inventory_item_id = eia.inventory_item_id
1301: AND eiai.organization_id = mp.master_organization_id
1302: AND mp.organization_id = eia.organization_id
1303: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL

Line 1573: FROM mtl_parameters mp

1569:
1570: -- Convert the master org values. Convert Organization Code to Organization Id
1571: UPDATE ego_item_associations_intf eiai
1572: SET organization_id = ( SELECT mp.organization_id
1573: FROM mtl_parameters mp
1574: WHERE mp.organization_code = eiai.organization_code
1575: AND mp.master_organization_id = mp.organization_id)
1576: WHERE eiai.batch_id = p_batch_id
1577: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)

Line 1585: FROM mtl_parameters mp

1581:
1582: -- Correct the organization id to master organization for double intersections
1583: UPDATE ego_item_associations_intf eiai
1584: SET organization_id = ( SELECT mp.master_organization_id
1585: FROM mtl_parameters mp
1586: WHERE mp.organization_id = eiai.organization_id)
1587: WHERE eiai.batch_id = p_batch_id
1588: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)
1589: AND ( eiai.data_level_id = G_ITEM_SUPPLIER_LEVEL OR eiai.data_level_id = G_ITEM_SUPPLIERSITE_LEVEL );

Line 1594: FROM mtl_parameters mp

1590:
1591: -- Convert the master org values. Convert Organization Code to Organization Id
1592: UPDATE ego_item_associations_intf eiai
1593: SET organization_id = ( SELECT mp.organization_id
1594: FROM mtl_parameters mp
1595: WHERE mp.organization_code = eiai.organization_code)
1596: WHERE eiai.batch_id = p_batch_id
1597: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)
1598: AND eiai.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL

Line 1604: FROM mtl_parameters mp

1600: AND eiai.organization_code IS NOT NULL;
1601: -- Convert the organization id to code in order to throw the errors for rules
1602: UPDATE ego_item_associations_intf eiai
1603: SET organization_code = ( SELECT mp.organization_code
1604: FROM mtl_parameters mp
1605: WHERE mp.organization_id = eiai.organization_id
1606: )
1607: WHERE eiai.batch_id = p_batch_id
1608: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)

Line 2000: FROM mtl_parameters

1996: /*
1997: BEGIN
1998: SELECT master_organization_id
1999: INTO l_master_org_id
2000: FROM mtl_parameters
2001: WHERE organization_id = p_from_org_id;
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN
2004: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 2060: ,mtl_parameters mp

2056: ,msii.bundle_id
2057: ,G_REQUEST_ID
2058: FROM ego_item_associations eia
2059: ,mtl_system_items_interface msii
2060: ,mtl_parameters mp
2061: WHERE eia.inventory_item_id = p_src_item_id
2062: -- AND msii.organization_id = mp.organization_id Copy_Item_Id will be populated only for master org items
2063: --AND mp.organization_id = mp.master_organization_id Copy all triple intersections
2064: AND msii.set_process_id = p_batch_id

Line 2217: ,mtl_parameters mp

2213: ,G_REQUEST_ID
2214: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2215: FROM ego_item_associations eia
2216: ,mtl_system_items_interface msii
2217: ,mtl_parameters mp
2218: ,mtl_system_items_interface msii2
2219: WHERE eia.inventory_item_id = msii2.style_item_id
2220: AND msii.organization_id = mp.organization_id
2221: AND msii.set_process_id = p_batch_id

Line 2295: ,mtl_parameters mp

2291: ,G_REQUEST_ID
2292: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2293: FROM ego_item_associations eia
2294: ,mtl_system_items_interface msii
2295: ,mtl_parameters mp
2296: WHERE eia.inventory_item_id = msii.style_item_id
2297: AND msii.organization_id = mp.organization_id
2298: --AND mp.organization_id = mp.master_organization_id
2299: AND msii.set_process_id = p_batch_id

Line 2373: ,mtl_parameters mp

2369: ,G_REQUEST_ID
2370: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2371: FROM ego_item_associations_intf eiai1
2372: ,mtl_system_items_b_kfv msibk
2373: ,mtl_parameters mp
2374: WHERE eiai1.inventory_item_id = msibk.style_item_id
2375: AND eiai1.organization_id = msibk.organization_id
2376: AND msibk.organization_id = mp.organization_id
2377: -- AND mp.organization_id = mp.master_organization_id

Line 2612: mtl_parameters mp

2608: ,mtl_system_items_interface_s.NEXTVAL
2609: ,G_REQUEST_ID
2610: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2611: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk,
2612: mtl_parameters mp
2613: WHERE eiai.inventory_item_id = l_pack_rec.inventory_item_id
2614: AND eiai.organization_id = mp.organization_id
2615: --AND mp.master_organization_id = mp.organization_id
2616: AND eiai.batch_id = p_batch_id