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

Line 1114: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

1110: NULL AS PK4_VALUE,
1111: NULL AS PK5_VALUE,
1112: #' || l_item_dl_id || q'# AS DATA_LEVEL_ID
1113: FROM
1114: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
1115: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
1116: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL
1117: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#
1118: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 1218: FROM MTL_PARAMETERS

1214: --AND ATTRS.PROCESS_STATUS = G_PS_IN_PROCESS
1215: AND ATTRS.PROCESS_STATUS = l_g_ps_in_process
1216: AND ATTRS.PROG_INT_CHAR1 = 'EXT_DEFAULT_VAL_ROW'
1217: AND EXISTS (SELECT 'X'
1218: FROM MTL_PARAMETERS
1219: WHERE ORGANIZATION_ID = ATTRS.ORGANIZATION_ID
1220: AND ORGANIZATION_ID <> MASTER_ORGANIZATION_ID);
1221: --Bug 7523737 End
1222:

Line 1262: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

1258: NULL AS PK4_VALUE,
1259: NULL AS PK5_VALUE,
1260: #' || l_item_gtin_dl_id || q'# AS DATA_LEVEL_ID
1261: FROM
1262: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
1263: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
1264: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL
1265: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#
1266: AND NVL(msii.GDSN_OUTBOUND_ENABLED_FLAG, 'N') = 'Y'

Line 1287: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

1283: NULL AS PK4_VALUE,
1284: NULL AS PK5_VALUE,
1285: #' || l_item_gtin_multi_dl_id || q'# AS DATA_LEVEL_ID
1286: FROM
1287: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
1288: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
1289: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL
1290: AND NVL(msii.GDSN_OUTBOUND_ENABLED_FLAG, 'N') = 'Y'
1291: AND NVL(msii.STYLE_ITEM_FLAG, 'Y') = 'Y'

Line 1779: MTL_PARAMETERS O,

1775: MSII.SET_PROCESS_ID,
1776: 'CREATE'
1777: FROM
1778: MTL_SYSTEM_ITEMS_INTERFACE MSII,
1779: MTL_PARAMETERS O,
1780: MTL_ITEM_CATEGORIES STYLE_CATS
1781: WHERE MSII.SET_PROCESS_ID = p_batch_id
1782: AND MSII.PROCESS_FLAG = 1
1783: AND MSII.TRANSACTION_TYPE = 'CREATE'

Line 2047: MTL_PARAMETERS MP

2043: MSII.COPY_ITEM_ID
2044: FROM
2045: MTL_SYSTEM_ITEMS_INTERFACE MSII,
2046: MTL_SYSTEM_ITEMS_B MSI,
2047: MTL_PARAMETERS MP
2048: WHERE MSII.SET_PROCESS_ID = p_batch_id
2049: AND MSII.PROCESS_FLAG = 1
2050: AND MSII.TRANSACTION_TYPE = 'CREATE'
2051: AND MSII.COPY_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 2319: MTL_PARAMETERS mp

2315: msii.TRANSACTION_ID,
2316: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2317: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2318: EGO_MTL_SY_ITEMS_EXT_VL ext_prod,
2319: MTL_PARAMETERS mp
2320: WHERE msii.STYLE_ITEM_FLAG = 'N'
2321: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2322: AND msii.TRANSACTION_TYPE = 'CREATE'
2323: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#

Line 2340: MTL_PARAMETERS mp

2336: SELECT
2337: ext_prod.ATTR_GROUP_ID
2338: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2339: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2340: MTL_PARAMETERS mp
2341: WHERE msii.STYLE_ITEM_FLAG = 'N'
2342: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2343: AND msii.TRANSACTION_TYPE = 'CREATE'
2344: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#

Line 2423: MTL_PARAMETERS mp

2419: msii.TRANSACTION_ID,
2420: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2421: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2422: EGO_MTL_SY_ITEMS_EXT_VL ext_prod,
2423: MTL_PARAMETERS mp
2424: WHERE msii.STYLE_ITEM_FLAG = 'N'
2425: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2426: AND msii.TRANSACTION_TYPE = 'CREATE'
2427: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#

Line 2453: MTL_PARAMETERS mp

2449: SELECT
2450: ext_prod.ATTR_GROUP_ID
2451: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2452: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2453: MTL_PARAMETERS mp
2454: WHERE msii.STYLE_ITEM_FLAG = 'N'
2455: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2456: AND msii.TRANSACTION_TYPE = 'CREATE'
2457: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#

Line 2654: MTL_PARAMETERS mp

2650: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2651: FROM
2652: MTL_SYSTEM_ITEMS_INTERFACE msii,
2653: EGO_MTL_SY_ITEMS_EXT_VL ext_prod,
2654: MTL_PARAMETERS mp
2655: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2656: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#
2657: AND msii.TRANSACTION_TYPE = 'CREATE'
2658: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 2681: MTL_PARAMETERS mp

2677: ext_prod.ATTR_GROUP_ID
2678: FROM
2679: MTL_SYSTEM_ITEMS_INTERFACE msii,
2680: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2681: MTL_PARAMETERS mp
2682: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2683: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#
2684: AND msii.TRANSACTION_TYPE = 'CREATE'
2685: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 2741: FROM MTL_SYSTEM_ITEMS_B msi, MTL_PARAMETERS mp

2737: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
2738: SET (STYLE_ITEM_FLAG, STYLE_ITEM_ID) = (SELECT
2739: msi.STYLE_ITEM_FLAG,
2740: msi.STYLE_ITEM_ID
2741: FROM MTL_SYSTEM_ITEMS_B msi, MTL_PARAMETERS mp
2742: WHERE msi.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2743: AND eiai.ORGANIZATION_ID = mp.ORGANIZATION_ID
2744: AND msi.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2745: )

Line 2750: FROM MTL_SYSTEM_ITEMS_B msi2, MTL_PARAMETERS mp2

2746: WHERE eiai.BATCH_ID = p_batch_id
2747: AND eiai.PROCESS_FLAG = 1
2748: AND eiai.TRANSACTION_TYPE = 'CREATE'
2749: AND EXISTS (SELECT NULL
2750: FROM MTL_SYSTEM_ITEMS_B msi2, MTL_PARAMETERS mp2
2751: WHERE msi2.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2752: AND eiai.ORGANIZATION_ID = mp2.ORGANIZATION_ID
2753: AND msi2.ORGANIZATION_ID = mp2.MASTER_ORGANIZATION_ID
2754: );

Line 2758: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

2754: );
2755:
2756: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
2757: SET (STYLE_ITEM_FLAG, STYLE_ITEM_ID) = (SELECT msii.STYLE_ITEM_FLAG , msii.STYLE_ITEM_ID
2758: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
2759: WHERE msii.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2760: AND eiai.ORGANIZATION_ID = mp.ORGANIZATION_ID
2761: AND msii.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2762: AND msii.SET_PROCESS_ID = eiai.BATCH_ID

Line 2769: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2, MTL_PARAMETERS mp2

2765: WHERE eiai.BATCH_ID = p_batch_id
2766: AND eiai.PROCESS_FLAG = 1
2767: AND eiai.TRANSACTION_TYPE = 'CREATE'
2768: AND EXISTS (SELECT 1
2769: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2, MTL_PARAMETERS mp2
2770: WHERE MSII2.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2771: AND MSII2.ORGANIZATION_ID = mp2.MASTER_ORGANIZATION_ID
2772: AND eiai.ORGANIZATION_ID = mp2.ORGANIZATION_ID
2773: AND MSII2.SET_PROCESS_ID = eiai.BATCH_ID

Line 3042: MTL_PARAMETERS mp

3038: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
3039: FROM
3040: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3041: EGO_MTL_SY_ITEMS_EXT_VL ext_prod,
3042: MTL_PARAMETERS mp
3043: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3044: AND eiai.TRANSACTION_TYPE = 'CREATE'
3045: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#
3046: AND eiai.PROCESS_FLAG = 1

Line 3080: MTL_PARAMETERS mp

3076: ext_prod.ATTR_GROUP_ID
3077: FROM
3078: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3079: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
3080: MTL_PARAMETERS mp
3081: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3082: AND eiai.TRANSACTION_TYPE = 'CREATE'
3083: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#
3084: AND eiai.PROCESS_FLAG = 1

Line 3233: MTL_PARAMETERS mp,

3229: ext_intf.DATA_LEVEL_ID
3230: FROM
3231: MTL_SYSTEM_ITEMS_INTERFACE msii,
3232: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3233: MTL_PARAMETERS mp,
3234: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3235: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
3236: AND msii.PROCESS_FLAG = 1
3237: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 3239: AND EXISTS (SELECT /+ push_subq / 1 FROM MTL_PARAMETERS mp1

3235: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
3236: AND msii.PROCESS_FLAG = 1
3237: AND msii.TRANSACTION_TYPE = 'CREATE'
3238: AND msii.STYLE_ITEM_ID IS NULL
3239: AND EXISTS (SELECT /*+ push_subq */ 1 FROM MTL_PARAMETERS mp1
3240: WHERE mp1.ORGANIZATION_ID = msii.ORGANIZATION_ID
3241: AND mp1.ORGANIZATION_ID <> mp1.MASTER_ORGANIZATION_ID
3242: )
3243: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 3520: MTL_PARAMETERS mp,

3516: eiai.DATA_LEVEL_ID
3517: FROM
3518: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3519: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3520: MTL_PARAMETERS mp,
3521: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3522: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3523: AND eiai.TRANSACTION_TYPE = 'CREATE'
3524: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#

Line 3627: MTL_PARAMETERS O,

3623: MSII.SET_PROCESS_ID,
3624: 'CREATE'
3625: FROM
3626: MTL_SYSTEM_ITEMS_INTERFACE MSII,
3627: MTL_PARAMETERS O,
3628: MTL_ITEM_CATEGORIES STYLE_CATS
3629: WHERE MSII.SET_PROCESS_ID = p_batch_id
3630: AND MSII.PROCESS_FLAG = p_msii_miri_process_flag -- Bug 12635842
3631: AND MSII.TRANSACTION_TYPE = 'CREATE'

Line 4123: mtl_parameters mp

4119: IS
4120: CURSOR cat_in_batch(p_batch_id NUMBER) IS
4121: SELECT DISTINCT msii.item_catalog_group_id AS item_catalog_group_id
4122: FROM mtl_system_items_interface msii,
4123: mtl_parameters mp
4124: WHERE msii.set_process_id = p_batch_id
4125: AND msii.process_flag = 1
4126: AND msii.transaction_type = 'CREATE'
4127: AND msii.item_catalog_group_id IS NOT NULL

Line 4152: -- FROM mtl_parameters mp

4148:
4149: -- Fix for bug#9660659 Start
4150: --UPDATE mtl_system_items_interface msii
4151: --SET msii.organization_code = (SELECT mp.organization_code
4152: -- FROM mtl_parameters mp
4153: -- WHERE mp.organization_id = msii.organization_id);
4154: --
4155: IF p_batch_id is not null THEN
4156:

Line 4159: FROM mtl_parameters mp

4155: IF p_batch_id is not null THEN
4156:
4157: UPDATE mtl_system_items_interface msii
4158: SET msii.organization_code = (SELECT mp.organization_code
4159: FROM mtl_parameters mp
4160: WHERE mp.organization_id = msii.organization_id)
4161: WHERE SET_PROCESS_ID = P_BATCH_ID;
4162:
4163: ELSE

Line 4167: FROM mtl_parameters mp

4163: ELSE
4164:
4165: UPDATE mtl_system_items_interface msii
4166: SET msii.organization_code = (SELECT mp.organization_code
4167: FROM mtl_parameters mp
4168: WHERE mp.organization_id = msii.organization_id);
4169: END IF;
4170: -- Fix for bug#9660659 End
4171:

Line 4365: mtl_parameters mp

4361: SYSDATE
4362: FROM ego_itm_usr_attr_intrfc a,
4363: /* Bug 10112500 - Start */
4364: mtl_system_items_interface msii,
4365: mtl_parameters mp
4366: /* Bug 10112500 - End */
4367: WHERE NOT EXISTS (SELECT NULL
4368: FROM ego_itm_usr_attr_intrfc b
4369: WHERE data_set_id = a.data_set_id

Line 4474: mtl_parameters mp

4470: SYSDATE,
4471: fnd_global.user_id,
4472: SYSDATE
4473: FROM mtl_system_items_interface msii,
4474: mtl_parameters mp
4475: WHERE msii.set_process_id = p_batch_id
4476: AND msii.process_flag = 1
4477: AND msii.transaction_type = 'CREATE' -- Bug 10112500
4478: AND Nvl(msii.style_item_flag,'N') = 'N'

Line 4917: FROM MTL_PARAMETERS MP

4913: AND PROCESS_FLAG = 1
4914: AND STYLE_ITEM_FLAG IN ('N', 'Y')
4915: AND UPPER(TRANSACTION_TYPE) IN ('CREATE', 'SYNC')
4916: AND EXISTS (SELECT NULL
4917: FROM MTL_PARAMETERS MP
4918: WHERE MP.ORGANIZATION_ID = MSII.ORGANIZATION_ID
4919: AND MP.ORGANIZATION_ID <> MP.MASTER_ORGANIZATION_ID)
4920: UNION
4921: SELECT

Line 4931: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_SYSTEM_ITEMS_INTERFACE MSII, MTL_PARAMETERS MP

4927: c_source_system_id AS SOURCE_SYSTEM_ID,
4928: MSI.ITEM_CATALOG_GROUP_ID,
4929: NULL,
4930: NULL
4931: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_SYSTEM_ITEMS_INTERFACE MSII, MTL_PARAMETERS MP
4932: WHERE MSII.SET_PROCESS_ID = p_batch_id
4933: AND MSII.PROCESS_FLAG = 1
4934: AND MSII.STYLE_ITEM_FLAG = 'N'
4935: AND UPPER(MSII.TRANSACTION_TYPE) = 'CREATE'

Line 4939: AND EXISTS (SELECT NULL FROM MTL_PARAMETERS MP1

4935: AND UPPER(MSII.TRANSACTION_TYPE) = 'CREATE'
4936: AND MSII.ORGANIZATION_ID = MP.ORGANIZATION_ID
4937: AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
4938: AND MSII.STYLE_ITEM_ID = MSI.INVENTORY_ITEM_ID
4939: AND EXISTS (SELECT NULL FROM MTL_PARAMETERS MP1
4940: WHERE MSI.ORGANIZATION_ID = MP1.ORGANIZATION_ID
4941: AND MP1.ORGANIZATION_ID <> MP1.MASTER_ORGANIZATION_ID)
4942: GROUP BY MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, MSI.CONCATENATED_SEGMENTS, MSI.INVENTORY_ITEM_ID, MSI.ITEM_CATALOG_GROUP_ID;
4943:

Line 4997: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP

4993: 'CREATE',
4994: MSI.ITEM_CATALOG_GROUP_ID,
4995: NULL,
4996: -99
4997: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP
4998: WHERE MSI.STYLE_ITEM_FLAG = 'N'
4999: AND MSI.STYLE_ITEM_ID = i.INVENTORY_ITEM_ID
5000: AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
5001: AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 5046: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII, MTL_PARAMETERS MP

5042: 'CREATE',
5043: MSII.ITEM_CATALOG_GROUP_ID,
5044: MSII.ITEM_CATALOG_GROUP_NAME,
5045: -99
5046: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII, MTL_PARAMETERS MP
5047: WHERE MSII.SET_PROCESS_ID = p_batch_id
5048: AND MSII.PROCESS_FLAG = 1
5049: AND MSII.STYLE_ITEM_FLAG = 'N'
5050: AND UPPER(MSII.TRANSACTION_TYPE) = 'CREATE'

Line 5645: MTL_PARAMETERS mp,

5641: intf.END_DATE
5642: FROM
5643: MTL_SYSTEM_ITEMS_KFV msik,
5644: EGO_ITEM_PEOPLE_INTF intf,
5645: MTL_PARAMETERS mp,
5646: FND_MENUS menus
5647: WHERE intf.DATA_SET_ID = p_batch_id
5648: AND intf.PROCESS_STATUS = 4
5649: AND intf.REQUEST_ID = cp_request_id

Line 5762: MTL_PARAMETERS mp

5758: AND mirb.EFFECTIVITY_DATE <= SYSDATE
5759: ) AS DEST_REVISION_ID
5760: FROM
5761: MTL_SYSTEM_ITEMS_INTERFACE msii,
5762: MTL_PARAMETERS mp
5763: WHERE msii.SET_PROCESS_ID = p_batch_id
5764: AND msii.PROCESS_FLAG = 7
5765: AND msii.TRANSACTION_TYPE = 'CREATE'
5766: AND msii.REQUEST_ID = c_request_id

Line 6892: MTL_PARAMETERS mp

6888: msii.INVENTORY_ITEM_ID AS DEST_ITEM_ID,
6889: msii.COPY_ORGANIZATION_ID AS SOURCE_ORG_ID,
6890: msii.COPY_ITEM_ID AS SOURCE_ITEM_ID
6891: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
6892: MTL_PARAMETERS mp
6893: WHERE msii.SET_PROCESS_ID = p_batch_id
6894: AND msii.PROCESS_FLAG = 7
6895: AND msii.TRANSACTION_TYPE = 'CREATE'
6896: AND msii.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID