DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3123: FROM MTL_SYSTEM_ITEMS_KFV

3119: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
3120: -- making sure that item_number always has a value for ready records
3121: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
3122: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
3123: FROM MTL_SYSTEM_ITEMS_KFV
3124: WHERE INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
3125: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID)
3126: WHERE SET_PROCESS_ID = p_batch_id
3127: AND PROCESS_FLAG = 1

Line 3816: FROM MTL_SYSTEM_ITEMS_KFV

3812: AND REVISION IS NULL;
3813:
3814: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
3815: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
3816: FROM MTL_SYSTEM_ITEMS_KFV
3817: WHERE INVENTORY_ITEM_ID = miri.INVENTORY_ITEM_ID
3818: AND ORGANIZATION_ID = miri.ORGANIZATION_ID)
3819: WHERE SET_PROCESS_ID = p_batch_id
3820: AND PROCESS_FLAG = 1

Line 4087: FROM MTL_SYSTEM_ITEMS_KFV

4083: AND PROCESS_FLAG = 1;
4084:
4085: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4086: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4087: FROM MTL_SYSTEM_ITEMS_KFV
4088: WHERE INVENTORY_ITEM_ID = mici.INVENTORY_ITEM_ID
4089: AND ORGANIZATION_ID = mici.ORGANIZATION_ID)
4090: WHERE SET_PROCESS_ID = p_batch_id
4091: AND PROCESS_FLAG = 1

Line 4354: FROM MTL_SYSTEM_ITEMS_KFV

4350: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
4351:
4352: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4353: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4354: FROM MTL_SYSTEM_ITEMS_KFV
4355: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
4356: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)
4357: WHERE DATA_SET_ID = p_batch_id
4358: AND PROCESS_STATUS = 1

Line 4677: FROM MTL_SYSTEM_ITEMS_KFV

4673: Debug_Conc_Log( l_proc_log_prefix || 'l_rev_dl_id: ' || l_rev_dl_id );
4674:
4675: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4676: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4677: FROM MTL_SYSTEM_ITEMS_KFV
4678: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
4679: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)
4680: WHERE DATA_SET_ID = p_batch_id
4681: AND PROCESS_STATUS = 1

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

5277: -- checking for duplicate GTIN
5278: IF NOT l_error THEN
5279: BEGIN
5280: SELECT CONCATENATED_SEGMENTS INTO l_existing_gtin
5281: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_CROSS_REFERENCES_B mcr, MTL_PARAMETERS mp
5282: WHERE msik.INVENTORY_ITEM_ID = mcr.INVENTORY_ITEM_ID
5283: AND msik.ORGANIZATION_ID = mp.ORGANIZATION_ID
5284: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
5285: AND mcr.CROSS_REFERENCE_TYPE = 'GTIN'

Line 5971: FROM MTL_SYSTEM_ITEMS_KFV

5967: ORGANIZATION_ID = l_org_id,
5968: ORGANIZATION_CODE = l_org_code,
5969: INVENTORY_ITEM_ID = p_inventory_item_id,
5970: ITEM_NUMBER = ( SELECT CONCATENATED_SEGMENTS
5971: FROM MTL_SYSTEM_ITEMS_KFV
5972: WHERE INVENTORY_ITEM_ID = p_inventory_item_id AND ORGANIZATION_ID = p_organization_id
5973: ),
5974: CONFIRM_STATUS =
5975: CASE

Line 6654: FROM MTL_SYSTEM_ITEMS_KFV MSIK

6650: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Done Resolving PK Values in Intersection Interface table' );
6651:
6652: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
6653: SET STYLE_ITEM_ID = (SELECT MSIK.INVENTORY_ITEM_ID
6654: FROM MTL_SYSTEM_ITEMS_KFV MSIK
6655: WHERE MSIK.CONCATENATED_SEGMENTS = MSII.STYLE_ITEM_NUMBER
6656: AND MSIK.ORGANIZATION_ID = MSII.ORGANIZATION_ID
6657: )
6658: WHERE SET_PROCESS_ID = p_data_set_id

Line 6673: FROM MTL_SYSTEM_ITEMS_KFV

6669: -- item_number
6670: -- so in the imported tab, we can join to the child entities by item_number alone
6671: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
6672: SET item_number = (SELECT CONCATENATED_SEGMENTS
6673: FROM MTL_SYSTEM_ITEMS_KFV
6674: WHERE INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
6675: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID)
6676: WHERE SET_PROCESS_ID = p_data_set_id
6677: AND PROCESS_FLAG = 1

Line 6683: FROM MTL_SYSTEM_ITEMS_KFV

6679: AND INVENTORY_ITEM_ID IS NOT NULL;
6680:
6681: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
6682: SET item_number = (SELECT CONCATENATED_SEGMENTS
6683: FROM MTL_SYSTEM_ITEMS_KFV
6684: WHERE INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID
6685: AND ORGANIZATION_ID = MIRI.ORGANIZATION_ID)
6686: WHERE SET_PROCESS_ID = p_data_set_id
6687: AND PROCESS_FLAG = 1

Line 6693: FROM MTL_SYSTEM_ITEMS_KFV

6689: AND INVENTORY_ITEM_ID IS NOT NULL;
6690:
6691: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
6692: SET item_number = (SELECT CONCATENATED_SEGMENTS
6693: FROM MTL_SYSTEM_ITEMS_KFV
6694: WHERE INVENTORY_ITEM_ID = MICI.INVENTORY_ITEM_ID
6695: AND ORGANIZATION_ID = MICI.ORGANIZATION_ID)
6696: WHERE SET_PROCESS_ID = p_data_set_id
6697: AND PROCESS_FLAG = 1

Line 6703: FROM MTL_SYSTEM_ITEMS_KFV

6699: AND INVENTORY_ITEM_ID IS NOT NULL;
6700:
6701: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
6702: SET item_number = (SELECT CONCATENATED_SEGMENTS
6703: FROM MTL_SYSTEM_ITEMS_KFV
6704: WHERE INVENTORY_ITEM_ID = EIUAI.INVENTORY_ITEM_ID
6705: AND ORGANIZATION_ID = EIUAI.ORGANIZATION_ID)
6706: WHERE DATA_SET_ID = p_data_set_id
6707: AND PROCESS_STATUS = 1

Line 6713: FROM MTL_SYSTEM_ITEMS_KFV

6709: AND INVENTORY_ITEM_ID IS NOT NULL;
6710:
6711: UPDATE EGO_AML_INTF EAI
6712: SET item_number = (SELECT CONCATENATED_SEGMENTS
6713: FROM MTL_SYSTEM_ITEMS_KFV
6714: WHERE INVENTORY_ITEM_ID = EAI.INVENTORY_ITEM_ID
6715: AND ORGANIZATION_ID = EAI.ORGANIZATION_ID)
6716: WHERE DATA_SET_ID = p_data_set_id
6717: AND PROCESS_FLAG = 1

Line 6723: FROM MTL_SYSTEM_ITEMS_KFV

6719: AND INVENTORY_ITEM_ID IS NOT NULL;
6720:
6721: UPDATE EGO_ITEM_PEOPLE_INTF MIPI
6722: SET item_number = (SELECT CONCATENATED_SEGMENTS
6723: FROM MTL_SYSTEM_ITEMS_KFV
6724: WHERE INVENTORY_ITEM_ID = MIPI.INVENTORY_ITEM_ID
6725: AND ORGANIZATION_ID = MIPI.ORGANIZATION_ID)
6726: WHERE DATA_SET_ID = p_data_set_id
6727: AND PROCESS_STATUS = 1

Line 6733: FROM MTL_SYSTEM_ITEMS_KFV

6729: AND INVENTORY_ITEM_ID IS NOT NULL;
6730:
6731: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6732: SET item_number = (SELECT CONCATENATED_SEGMENTS
6733: FROM MTL_SYSTEM_ITEMS_KFV
6734: WHERE INVENTORY_ITEM_ID = EIAI.INVENTORY_ITEM_ID
6735: AND ORGANIZATION_ID = EIAI.ORGANIZATION_ID)
6736: WHERE BATCH_ID = p_data_set_id
6737: AND PROCESS_FLAG = 1

Line 7535: FROM MTL_SYSTEM_ITEMS_KFV

7531:
7532: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Updating item_number and revision, l_ss_id='||l_ss_id);
7533: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
7534: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
7535: FROM MTL_SYSTEM_ITEMS_KFV
7536: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
7537: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)
7538: WHERE DATA_SET_ID = p_batch_id
7539: AND PROCESS_STATUS = p_process_status

Line 8001: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp

7997: 'Y', 'Y'
7998: ),
7999: NVL(MAX(msik.STYLE_ITEM_ID), msii.STYLE_ITEM_ID),
8000: NVL(msii.INVENTORY_ITEM_ID, MAX(msik.INVENTORY_ITEM_ID))
8001: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp
8002: WHERE (msii.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
8003: OR msii.ITEM_NUMBER = msik.CONCATENATED_SEGMENTS)
8004: AND msik.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
8005: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 9307: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp

9303: 'N', 'N',
9304: 'Y', 'Y'
9305: ),
9306: NVL(MAX(msik.STYLE_ITEM_ID), msii.STYLE_ITEM_ID)
9307: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp
9308: WHERE (msii.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
9309: OR msii.ITEM_NUMBER = msik.CONCATENATED_SEGMENTS)
9310: AND msik.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
9311: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 9803: MTL_SYSTEM_ITEMS_KFV MSIK

9799: INTO l_xref_item_number
9800: , l_xref_item_id
9801: , l_xref_desc
9802: FROM MTL_CROSS_REFERENCES MCR,
9803: MTL_SYSTEM_ITEMS_KFV MSIK
9804: WHERE MCR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
9805: AND MSIK.ORGANIZATION_ID = l_org_id
9806: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9807: AND MCR.SOURCE_SYSTEM_ID = l_ss_id