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_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3185: FROM MTL_SYSTEM_ITEMS_KFV

3181: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
3182: -- making sure that item_number always has a value for ready records
3183: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
3184: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
3185: FROM MTL_SYSTEM_ITEMS_KFV
3186: WHERE INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
3187: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID)
3188: WHERE SET_PROCESS_ID = p_batch_id
3189: AND PROCESS_FLAG = 1

Line 3878: FROM MTL_SYSTEM_ITEMS_KFV

3874: AND REVISION IS NULL;
3875:
3876: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
3877: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
3878: FROM MTL_SYSTEM_ITEMS_KFV
3879: WHERE INVENTORY_ITEM_ID = miri.INVENTORY_ITEM_ID
3880: AND ORGANIZATION_ID = miri.ORGANIZATION_ID)
3881: WHERE SET_PROCESS_ID = p_batch_id
3882: AND PROCESS_FLAG = 1

Line 4149: FROM MTL_SYSTEM_ITEMS_KFV

4145: AND PROCESS_FLAG = 1;
4146:
4147: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4148: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4149: FROM MTL_SYSTEM_ITEMS_KFV
4150: WHERE INVENTORY_ITEM_ID = mici.INVENTORY_ITEM_ID
4151: AND ORGANIZATION_ID = mici.ORGANIZATION_ID)
4152: WHERE SET_PROCESS_ID = p_batch_id
4153: AND PROCESS_FLAG = 1

Line 4419: FROM MTL_SYSTEM_ITEMS_KFV

4415: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
4416:
4417: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4418: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4419: FROM MTL_SYSTEM_ITEMS_KFV
4420: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
4421: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)
4422: WHERE DATA_SET_ID = p_batch_id
4423: AND PROCESS_STATUS = 1

Line 4742: FROM MTL_SYSTEM_ITEMS_KFV

4738: Debug_Conc_Log( l_proc_log_prefix || 'l_rev_dl_id: ' || l_rev_dl_id );
4739:
4740: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4741: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4742: FROM MTL_SYSTEM_ITEMS_KFV
4743: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
4744: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)
4745: WHERE DATA_SET_ID = p_batch_id
4746: AND PROCESS_STATUS = 1

Line 5347: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_CROSS_REFERENCES_B mcr, MTL_PARAMETERS mp

5343: -- checking for duplicate GTIN
5344: IF NOT l_error THEN
5345: BEGIN
5346: SELECT CONCATENATED_SEGMENTS INTO l_existing_gtin
5347: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_CROSS_REFERENCES_B mcr, MTL_PARAMETERS mp
5348: WHERE msik.INVENTORY_ITEM_ID = mcr.INVENTORY_ITEM_ID
5349: AND msik.ORGANIZATION_ID = mp.ORGANIZATION_ID
5350: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
5351: AND mcr.CROSS_REFERENCE_TYPE = 'GTIN'

Line 6038: In below query Item_number is fetched from MTL_SYSTEM_ITEMS_KFV based on p_inventory_item_id and p_organization_id

6034: If p_status is G_CONF_NEW, update DESCRIPTION with SOURCE_SYSTEM_REFERENCE_DES, if DESCRIPTION is not provided, otherwise
6035: retain DESCRIPTION.
6036: */
6037: /* start bug 16309495
6038: In below query Item_number is fetched from MTL_SYSTEM_ITEMS_KFV based on p_inventory_item_id and p_organization_id
6039: and updates MTL_SYSTEM_ITEMS_INTERFACE.
6040: This will fire only for Single Match case.
6041: As we are populating INVENTORY_ITEM_ID,ORGANIZATION_ID
6042: There is no harm in removing ITEM_NUMBER.

Line 6739: FROM MTL_SYSTEM_ITEMS_KFV MSIK

6735: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Done Resolving PK Values in Intersection Interface table' );
6736:
6737: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
6738: SET STYLE_ITEM_ID = (SELECT MSIK.INVENTORY_ITEM_ID
6739: FROM MTL_SYSTEM_ITEMS_KFV MSIK
6740: WHERE MSIK.CONCATENATED_SEGMENTS = MSII.STYLE_ITEM_NUMBER
6741: AND MSIK.ORGANIZATION_ID = MSII.ORGANIZATION_ID
6742: )
6743: WHERE SET_PROCESS_ID = p_data_set_id

Line 6758: FROM MTL_SYSTEM_ITEMS_KFV

6754: -- item_number
6755: -- so in the imported tab, we can join to the child entities by item_number alone
6756: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
6757: SET item_number = (SELECT CONCATENATED_SEGMENTS
6758: FROM MTL_SYSTEM_ITEMS_KFV
6759: WHERE INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
6760: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID)
6761: WHERE SET_PROCESS_ID = p_data_set_id
6762: AND PROCESS_FLAG = 1

Line 6768: FROM MTL_SYSTEM_ITEMS_KFV

6764: AND INVENTORY_ITEM_ID IS NOT NULL;
6765:
6766: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
6767: SET item_number = (SELECT CONCATENATED_SEGMENTS
6768: FROM MTL_SYSTEM_ITEMS_KFV
6769: WHERE INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID
6770: AND ORGANIZATION_ID = MIRI.ORGANIZATION_ID)
6771: WHERE SET_PROCESS_ID = p_data_set_id
6772: AND PROCESS_FLAG = 1

Line 6778: FROM MTL_SYSTEM_ITEMS_KFV

6774: AND INVENTORY_ITEM_ID IS NOT NULL;
6775:
6776: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
6777: SET item_number = (SELECT CONCATENATED_SEGMENTS
6778: FROM MTL_SYSTEM_ITEMS_KFV
6779: WHERE INVENTORY_ITEM_ID = MICI.INVENTORY_ITEM_ID
6780: AND ORGANIZATION_ID = MICI.ORGANIZATION_ID)
6781: WHERE SET_PROCESS_ID = p_data_set_id
6782: AND PROCESS_FLAG = 1

Line 6788: FROM MTL_SYSTEM_ITEMS_KFV

6784: AND INVENTORY_ITEM_ID IS NOT NULL;
6785:
6786: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
6787: SET item_number = (SELECT CONCATENATED_SEGMENTS
6788: FROM MTL_SYSTEM_ITEMS_KFV
6789: WHERE INVENTORY_ITEM_ID = EIUAI.INVENTORY_ITEM_ID
6790: AND ORGANIZATION_ID = EIUAI.ORGANIZATION_ID)
6791: WHERE DATA_SET_ID = p_data_set_id
6792: AND PROCESS_STATUS = 1

Line 6798: FROM MTL_SYSTEM_ITEMS_KFV

6794: AND INVENTORY_ITEM_ID IS NOT NULL;
6795:
6796: UPDATE EGO_AML_INTF EAI
6797: SET item_number = (SELECT CONCATENATED_SEGMENTS
6798: FROM MTL_SYSTEM_ITEMS_KFV
6799: WHERE INVENTORY_ITEM_ID = EAI.INVENTORY_ITEM_ID
6800: AND ORGANIZATION_ID = EAI.ORGANIZATION_ID)
6801: WHERE DATA_SET_ID = p_data_set_id
6802: AND PROCESS_FLAG = 1

Line 6808: FROM MTL_SYSTEM_ITEMS_KFV

6804: AND INVENTORY_ITEM_ID IS NOT NULL;
6805:
6806: UPDATE EGO_ITEM_PEOPLE_INTF MIPI
6807: SET item_number = (SELECT CONCATENATED_SEGMENTS
6808: FROM MTL_SYSTEM_ITEMS_KFV
6809: WHERE INVENTORY_ITEM_ID = MIPI.INVENTORY_ITEM_ID
6810: AND ORGANIZATION_ID = MIPI.ORGANIZATION_ID)
6811: WHERE DATA_SET_ID = p_data_set_id
6812: AND PROCESS_STATUS = 1

Line 6818: FROM MTL_SYSTEM_ITEMS_KFV

6814: AND INVENTORY_ITEM_ID IS NOT NULL;
6815:
6816: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6817: SET item_number = (SELECT CONCATENATED_SEGMENTS
6818: FROM MTL_SYSTEM_ITEMS_KFV
6819: WHERE INVENTORY_ITEM_ID = EIAI.INVENTORY_ITEM_ID
6820: AND ORGANIZATION_ID = EIAI.ORGANIZATION_ID)
6821: WHERE BATCH_ID = p_data_set_id
6822: AND PROCESS_FLAG = 1

Line 7632: FROM MTL_SYSTEM_ITEMS_KFV

7628:
7629: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Updating item_number and revision, l_ss_id='||l_ss_id);
7630: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
7631: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
7632: FROM MTL_SYSTEM_ITEMS_KFV
7633: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
7634: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)
7635: WHERE DATA_SET_ID = p_batch_id
7636: AND PROCESS_STATUS = p_process_status

Line 8104: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp

8100: 'Y', 'Y'
8101: ),
8102: NVL(MAX(msik.STYLE_ITEM_ID), msii.STYLE_ITEM_ID),
8103: NVL(msii.INVENTORY_ITEM_ID, MAX(msik.INVENTORY_ITEM_ID))
8104: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp
8105: WHERE (msii.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
8106: OR msii.ITEM_NUMBER = msik.CONCATENATED_SEGMENTS)
8107: AND msik.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
8108: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 9410: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp

9406: 'N', 'N',
9407: 'Y', 'Y'
9408: ),
9409: NVL(MAX(msik.STYLE_ITEM_ID), msii.STYLE_ITEM_ID)
9410: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp
9411: WHERE (msii.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
9412: OR msii.ITEM_NUMBER = msik.CONCATENATED_SEGMENTS)
9413: AND msik.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
9414: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 9906: MTL_SYSTEM_ITEMS_KFV MSIK

9902: INTO l_xref_item_number
9903: , l_xref_item_id
9904: , l_xref_desc
9905: FROM MTL_CROSS_REFERENCES MCR,
9906: MTL_SYSTEM_ITEMS_KFV MSIK
9907: WHERE MCR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
9908: AND MSIK.ORGANIZATION_ID = l_org_id
9909: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9910: AND MCR.SOURCE_SYSTEM_ID = l_ss_id