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 1004: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

1000: NULL AS PK4_VALUE,
1001: NULL AS PK5_VALUE,
1002: #' || l_item_dl_id || q'# AS DATA_LEVEL_ID
1003: FROM
1004: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
1005: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
1006: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL
1007: AND msii.PROCESS_FLAG = 1
1008: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 1105: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

1101: NULL AS PK4_VALUE,
1102: NULL AS PK5_VALUE,
1103: #' || l_item_gtin_dl_id || q'# AS DATA_LEVEL_ID
1104: FROM
1105: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
1106: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
1107: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL
1108: AND msii.PROCESS_FLAG = 1
1109: AND NVL(msii.GDSN_OUTBOUND_ENABLED_FLAG, 'N') = 'Y'

Line 1130: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

1126: NULL AS PK4_VALUE,
1127: NULL AS PK5_VALUE,
1128: #' || l_item_gtin_multi_dl_id || q'# AS DATA_LEVEL_ID
1129: FROM
1130: MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
1131: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
1132: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL
1133: AND NVL(msii.GDSN_OUTBOUND_ENABLED_FLAG, 'N') = 'Y'
1134: AND NVL(msii.STYLE_ITEM_FLAG, 'Y') = 'Y'

Line 1609: MTL_PARAMETERS O,

1605: MSII.SET_PROCESS_ID,
1606: 'CREATE'
1607: FROM
1608: MTL_SYSTEM_ITEMS_INTERFACE MSII,
1609: MTL_PARAMETERS O,
1610: MTL_ITEM_CATEGORIES STYLE_CATS
1611: WHERE MSII.SET_PROCESS_ID = p_batch_id
1612: AND MSII.PROCESS_FLAG = 1
1613: AND MSII.TRANSACTION_TYPE = 'CREATE'

Line 1877: MTL_PARAMETERS MP

1873: MSII.COPY_ITEM_ID
1874: FROM
1875: MTL_SYSTEM_ITEMS_INTERFACE MSII,
1876: MTL_SYSTEM_ITEMS_B MSI,
1877: MTL_PARAMETERS MP
1878: WHERE MSII.SET_PROCESS_ID = p_batch_id
1879: AND MSII.PROCESS_FLAG = 1
1880: AND MSII.TRANSACTION_TYPE = 'CREATE'
1881: AND MSII.COPY_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 2145: MTL_PARAMETERS mp

2141: msii.TRANSACTION_ID,
2142: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2143: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2144: EGO_MTL_SY_ITEMS_EXT_VL ext_prod,
2145: MTL_PARAMETERS mp
2146: WHERE msii.STYLE_ITEM_FLAG = 'N'
2147: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2148: AND msii.TRANSACTION_TYPE = 'CREATE'
2149: AND msii.PROCESS_FLAG = 1

Line 2166: MTL_PARAMETERS mp

2162: SELECT
2163: ext_prod.ATTR_GROUP_ID
2164: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2165: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2166: MTL_PARAMETERS mp
2167: WHERE msii.STYLE_ITEM_FLAG = 'N'
2168: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2169: AND msii.TRANSACTION_TYPE = 'CREATE'
2170: AND msii.PROCESS_FLAG = 1

Line 2248: MTL_PARAMETERS mp

2244: msii.TRANSACTION_ID,
2245: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2246: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2247: EGO_MTL_SY_ITEMS_EXT_VL ext_prod,
2248: MTL_PARAMETERS mp
2249: WHERE msii.STYLE_ITEM_FLAG = 'N'
2250: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2251: AND msii.TRANSACTION_TYPE = 'CREATE'
2252: AND msii.PROCESS_FLAG = 1

Line 2276: MTL_PARAMETERS mp

2272: SELECT
2273: ext_prod.ATTR_GROUP_ID
2274: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2275: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2276: MTL_PARAMETERS mp
2277: WHERE msii.STYLE_ITEM_FLAG = 'N'
2278: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2279: AND msii.TRANSACTION_TYPE = 'CREATE'
2280: AND msii.PROCESS_FLAG = 1

Line 2465: MTL_PARAMETERS mp

2461: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2462: FROM
2463: MTL_SYSTEM_ITEMS_INTERFACE msii,
2464: EGO_MTL_SY_ITEMS_EXT_VL ext_prod,
2465: MTL_PARAMETERS mp
2466: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2467: AND msii.PROCESS_FLAG = 1
2468: AND msii.TRANSACTION_TYPE = 'CREATE'
2469: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 2492: MTL_PARAMETERS mp

2488: ext_prod.ATTR_GROUP_ID
2489: FROM
2490: MTL_SYSTEM_ITEMS_INTERFACE msii,
2491: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2492: MTL_PARAMETERS mp
2493: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2494: AND msii.PROCESS_FLAG = 1
2495: AND msii.TRANSACTION_TYPE = 'CREATE'
2496: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 2552: FROM MTL_SYSTEM_ITEMS_B msi, MTL_PARAMETERS mp

2548: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
2549: SET (STYLE_ITEM_FLAG, STYLE_ITEM_ID) = (SELECT
2550: msi.STYLE_ITEM_FLAG,
2551: msi.STYLE_ITEM_ID
2552: FROM MTL_SYSTEM_ITEMS_B msi, MTL_PARAMETERS mp
2553: WHERE msi.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2554: AND eiai.ORGANIZATION_ID = mp.ORGANIZATION_ID
2555: AND msi.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2556: )

Line 2561: FROM MTL_SYSTEM_ITEMS_B msi2, MTL_PARAMETERS mp2

2557: WHERE eiai.BATCH_ID = p_batch_id
2558: AND eiai.PROCESS_FLAG = 1
2559: AND eiai.TRANSACTION_TYPE = 'CREATE'
2560: AND EXISTS (SELECT NULL
2561: FROM MTL_SYSTEM_ITEMS_B msi2, MTL_PARAMETERS mp2
2562: WHERE msi2.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2563: AND eiai.ORGANIZATION_ID = mp2.ORGANIZATION_ID
2564: AND msi2.ORGANIZATION_ID = mp2.MASTER_ORGANIZATION_ID
2565: );

Line 2569: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

2565: );
2566:
2567: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
2568: SET (STYLE_ITEM_FLAG, STYLE_ITEM_ID) = (SELECT msii.STYLE_ITEM_FLAG , msii.STYLE_ITEM_ID
2569: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
2570: WHERE msii.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2571: AND eiai.ORGANIZATION_ID = mp.ORGANIZATION_ID
2572: AND msii.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2573: AND msii.SET_PROCESS_ID = eiai.BATCH_ID

Line 2580: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2, MTL_PARAMETERS mp2

2576: WHERE eiai.BATCH_ID = p_batch_id
2577: AND eiai.PROCESS_FLAG = 1
2578: AND eiai.TRANSACTION_TYPE = 'CREATE'
2579: AND EXISTS (SELECT 1
2580: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2, MTL_PARAMETERS mp2
2581: WHERE MSII2.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2582: AND MSII2.ORGANIZATION_ID = mp2.MASTER_ORGANIZATION_ID
2583: AND eiai.ORGANIZATION_ID = mp2.ORGANIZATION_ID
2584: AND MSII2.SET_PROCESS_ID = eiai.BATCH_ID

Line 2853: MTL_PARAMETERS mp

2849: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2850: FROM
2851: EGO_ITEM_ASSOCIATIONS_INTF eiai,
2852: EGO_MTL_SY_ITEMS_EXT_VL ext_prod,
2853: MTL_PARAMETERS mp
2854: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
2855: AND eiai.TRANSACTION_TYPE = 'CREATE'
2856: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#
2857: AND eiai.PROCESS_FLAG = 1

Line 2891: MTL_PARAMETERS mp

2887: ext_prod.ATTR_GROUP_ID
2888: FROM
2889: EGO_ITEM_ASSOCIATIONS_INTF eiai,
2890: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2891: MTL_PARAMETERS mp
2892: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
2893: AND eiai.TRANSACTION_TYPE = 'CREATE'
2894: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#
2895: AND eiai.PROCESS_FLAG = 1

Line 3043: MTL_PARAMETERS mp,

3039: ext_intf.DATA_LEVEL_ID
3040: FROM
3041: MTL_SYSTEM_ITEMS_INTERFACE msii,
3042: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3043: MTL_PARAMETERS mp,
3044: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3045: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
3046: AND msii.PROCESS_FLAG = 1
3047: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 3049: AND EXISTS (SELECT 1 FROM MTL_PARAMETERS mp1

3045: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
3046: AND msii.PROCESS_FLAG = 1
3047: AND msii.TRANSACTION_TYPE = 'CREATE'
3048: AND msii.STYLE_ITEM_ID IS NULL
3049: AND EXISTS (SELECT 1 FROM MTL_PARAMETERS mp1
3050: WHERE mp1.ORGANIZATION_ID = msii.ORGANIZATION_ID
3051: AND mp1.ORGANIZATION_ID <> mp1.MASTER_ORGANIZATION_ID
3052: )
3053: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 3330: MTL_PARAMETERS mp,

3326: eiai.DATA_LEVEL_ID
3327: FROM
3328: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3329: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3330: MTL_PARAMETERS mp,
3331: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3332: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3333: AND eiai.TRANSACTION_TYPE = 'CREATE'
3334: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#

Line 3436: MTL_PARAMETERS O,

3432: MSII.SET_PROCESS_ID,
3433: 'CREATE'
3434: FROM
3435: MTL_SYSTEM_ITEMS_INTERFACE MSII,
3436: MTL_PARAMETERS O,
3437: MTL_ITEM_CATEGORIES STYLE_CATS
3438: WHERE MSII.SET_PROCESS_ID = p_batch_id
3439: AND MSII.PROCESS_FLAG = 1
3440: AND MSII.TRANSACTION_TYPE = 'CREATE'

Line 4221: FROM MTL_PARAMETERS MP

4217: AND PROCESS_FLAG = 1
4218: AND STYLE_ITEM_FLAG IN ('N', 'Y')
4219: AND UPPER(TRANSACTION_TYPE) IN ('CREATE', 'SYNC')
4220: AND EXISTS (SELECT NULL
4221: FROM MTL_PARAMETERS MP
4222: WHERE MP.ORGANIZATION_ID = MSII.ORGANIZATION_ID
4223: AND MP.ORGANIZATION_ID <> MP.MASTER_ORGANIZATION_ID)
4224: UNION
4225: SELECT

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

4230: MSI.INVENTORY_ITEM_ID AS STYLE_ITEM_ID,
4231: c_source_system_id AS SOURCE_SYSTEM_ID,
4232: MSI.ITEM_CATALOG_GROUP_ID,
4233: NULL
4234: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_SYSTEM_ITEMS_INTERFACE MSII, MTL_PARAMETERS MP
4235: WHERE MSII.SET_PROCESS_ID = p_batch_id
4236: AND MSII.PROCESS_FLAG = 1
4237: AND MSII.STYLE_ITEM_FLAG = 'N'
4238: AND UPPER(MSII.TRANSACTION_TYPE) = 'CREATE'

Line 4242: AND EXISTS (SELECT NULL FROM MTL_PARAMETERS MP1

4238: AND UPPER(MSII.TRANSACTION_TYPE) = 'CREATE'
4239: AND MSII.ORGANIZATION_ID = MP.ORGANIZATION_ID
4240: AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
4241: AND MSII.STYLE_ITEM_ID = MSI.INVENTORY_ITEM_ID
4242: AND EXISTS (SELECT NULL FROM MTL_PARAMETERS MP1
4243: WHERE MSI.ORGANIZATION_ID = MP1.ORGANIZATION_ID
4244: AND MP1.ORGANIZATION_ID <> MP1.MASTER_ORGANIZATION_ID)
4245: GROUP BY MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, MSI.CONCATENATED_SEGMENTS, MSI.INVENTORY_ITEM_ID, MSI.ITEM_CATALOG_GROUP_ID;
4246:

Line 4300: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP

4296: 'CREATE',
4297: MSI.ITEM_CATALOG_GROUP_ID,
4298: NULL,
4299: -99
4300: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP
4301: WHERE MSI.STYLE_ITEM_FLAG = 'N'
4302: AND MSI.STYLE_ITEM_ID = i.INVENTORY_ITEM_ID
4303: AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
4304: AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 4349: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII, MTL_PARAMETERS MP

4345: 'CREATE',
4346: MSII.ITEM_CATALOG_GROUP_ID,
4347: MSII.ITEM_CATALOG_GROUP_NAME,
4348: -99
4349: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII, MTL_PARAMETERS MP
4350: WHERE MSII.SET_PROCESS_ID = p_batch_id
4351: AND MSII.PROCESS_FLAG = 1
4352: AND MSII.STYLE_ITEM_FLAG = 'N'
4353: AND UPPER(MSII.TRANSACTION_TYPE) = 'CREATE'

Line 4895: MTL_PARAMETERS mp,

4891: intf.END_DATE
4892: FROM
4893: MTL_SYSTEM_ITEMS_KFV msik,
4894: EGO_ITEM_PEOPLE_INTF intf,
4895: MTL_PARAMETERS mp,
4896: FND_MENUS menus
4897: WHERE intf.DATA_SET_ID = p_batch_id
4898: AND intf.PROCESS_STATUS = 4
4899: AND intf.REQUEST_ID = cp_request_id

Line 5012: MTL_PARAMETERS mp

5008: AND mirb.EFFECTIVITY_DATE <= SYSDATE
5009: ) AS DEST_REVISION_ID
5010: FROM
5011: MTL_SYSTEM_ITEMS_INTERFACE msii,
5012: MTL_PARAMETERS mp
5013: WHERE msii.SET_PROCESS_ID = p_batch_id
5014: AND msii.PROCESS_FLAG = 7
5015: AND msii.TRANSACTION_TYPE = 'CREATE'
5016: AND msii.REQUEST_ID = c_request_id

Line 6108: MTL_PARAMETERS mp

6104: msii.INVENTORY_ITEM_ID AS DEST_ITEM_ID,
6105: msii.COPY_ORGANIZATION_ID AS SOURCE_ORG_ID,
6106: msii.COPY_ITEM_ID AS SOURCE_ITEM_ID
6107: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
6108: MTL_PARAMETERS mp
6109: WHERE msii.SET_PROCESS_ID = p_batch_id
6110: AND msii.PROCESS_FLAG = 7
6111: AND msii.TRANSACTION_TYPE = 'CREATE'
6112: AND msii.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID