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_ITEM_CATEGORIES_INTERFACE

Line 122: FROM MTL_ITEM_CATEGORIES_INTERFACE

118: SELECT
119: ORGANIZATION_ID,
120: TRANSACTION_ID,
121: PROCESS_FLAG
122: FROM MTL_ITEM_CATEGORIES_INTERFACE
123: WHERE SET_PROCESS_ID = p_data_set_id
124: AND PROCESS_FLAG IN (33379, 33389);
125:
126: CURSOR c_ssxref_null_eiuai IS

Line 199: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

195: )
196: );
197:
198: -- MICI
199: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
200: SET PROCESS_FLAG = (CASE WHEN MICI.SOURCE_SYSTEM_REFERENCE IS NULL THEN 33379 ELSE 33389 END),
201: TRANSACTION_ID = NVL(TRANSACTION_ID, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
202: PROGRAM_APPLICATION_ID = l_prog_appid,
203: PROGRAM_ID = l_prog_id,

Line 375: ,'MTL_ITEM_CATEGORIES_INTERFACE'

371: ,l_request_id
372: ,i.TRANSACTION_ID
373: ,l_msg_text
374: ,'SOURCE_SYSTEM_REFERENCE'
375: ,'MTL_ITEM_CATEGORIES_INTERFACE'
376: ,'INV_IOI_ERR'
377: ,l_err_text);
378: ELSIF i.PROCESS_FLAG = 33389 THEN
379: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

Line 391: ,'MTL_ITEM_CATEGORIES_INTERFACE'

387: ,l_request_id
388: ,i.TRANSACTION_ID
389: ,l_msg_text
390: ,'SOURCE_SYSTEM_ID'
391: ,'MTL_ITEM_CATEGORIES_INTERFACE'
392: ,'INV_IOI_ERR'
393: ,l_err_text);
394: END IF;
395: END LOOP;

Line 558: UPDATE MTL_ITEM_CATEGORIES_INTERFACE

554: SET PROCESS_FLAG =3
555: WHERE PROCESS_FLAG IN (33379, 33389)
556: AND SET_PROCESS_ID = p_data_set_id;
557:
558: UPDATE MTL_ITEM_CATEGORIES_INTERFACE
559: SET PROCESS_FLAG =3
560: WHERE PROCESS_FLAG IN (33379, 33389)
561: AND SET_PROCESS_ID = p_data_set_id;
562:

Line 660: -- checking whether stats needs to be collected on MTL_ITEM_CATEGORIES_INTERFACE

656: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
657: Debug_Conc_Log('Collected Statistics on MTL_ITEM_REVISIONS_INTERFACE');
658: END IF;
659:
660: -- checking whether stats needs to be collected on MTL_ITEM_CATEGORIES_INTERFACE
661: SELECT COUNT(1) INTO l_records
662: FROM MTL_ITEM_CATEGORIES_INTERFACE
663: WHERE SET_PROCESS_ID = p_data_set_id;
664:

Line 662: FROM MTL_ITEM_CATEGORIES_INTERFACE

658: END IF;
659:
660: -- checking whether stats needs to be collected on MTL_ITEM_CATEGORIES_INTERFACE
661: SELECT COUNT(1) INTO l_records
662: FROM MTL_ITEM_CATEGORIES_INTERFACE
663: WHERE SET_PROCESS_ID = p_data_set_id;
664:
665: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
666: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');

Line 666: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');

662: FROM MTL_ITEM_CATEGORIES_INTERFACE
663: WHERE SET_PROCESS_ID = p_data_set_id;
664:
665: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
666: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
667: Debug_Conc_Log('Collected Statistics on MTL_ITEM_CATEGORIES_INTERFACE');
668: END IF;
669:
670: l_ego_installed := FND_INSTALLATION.GET_APP_INFO('EGO', l_status, l_industry, l_schema);

Line 667: Debug_Conc_Log('Collected Statistics on MTL_ITEM_CATEGORIES_INTERFACE');

663: WHERE SET_PROCESS_ID = p_data_set_id;
664:
665: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
666: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
667: Debug_Conc_Log('Collected Statistics on MTL_ITEM_CATEGORIES_INTERFACE');
668: END IF;
669:
670: l_ego_installed := FND_INSTALLATION.GET_APP_INFO('EGO', l_status, l_industry, l_schema);
671: -- checking whether stats needs to be collected on EGO_ITEM_PEOPLE_INTF

Line 4015: SUBTYPE MICI_ROW IS MTL_ITEM_CATEGORIES_INTERFACE%ROWTYPE;

4011: PROCEDURE Merge_Categories_For_Import( p_batch_id IN NUMBER
4012: , p_master_org_id IN NUMBER
4013: )
4014: IS
4015: SUBTYPE MICI_ROW IS MTL_ITEM_CATEGORIES_INTERFACE%ROWTYPE;
4016: TYPE MICI_ROWS IS TABLE OF MICI_ROW INDEX BY BINARY_INTEGER;
4017:
4018: /*
4019: * Note that the organization_id column is filled in from the organization_code and batch organization_id

Line 4030: FROM MTL_ITEM_CATEGORIES_INTERFACE mici

4026: ROWID rid,
4027: COUNT( * ) OVER ( PARTITION BY ITEM_NUMBER, ORGANIZATION_ID, CATEGORY_SET_NAME, CATEGORY_NAME ) cnt,
4028: RANK() OVER ( ORDER BY ITEM_NUMBER, ORGANIZATION_ID, CATEGORY_SET_NAME, CATEGORY_NAME ) rnk,
4029: mici.*
4030: FROM MTL_ITEM_CATEGORIES_INTERFACE mici
4031: WHERE PROCESS_FLAG = 1
4032: AND SET_PROCESS_ID = p_batch_id
4033: AND ITEM_NUMBER IS NOT NULL
4034: AND ORGANIZATION_ID IS NOT NULL

Line 4055: l_candidate_trans MTL_ITEM_CATEGORIES_INTERFACE.TRANSACTION_TYPE%TYPE;

4051: l_merged_row MICI_ROW;
4052: l_old_rows TARGET_ROWS;
4053: l_old_rowids UROWID_TABLE;
4054:
4055: l_candidate_trans MTL_ITEM_CATEGORIES_INTERFACE.TRANSACTION_TYPE%TYPE;
4056:
4057: l_mrow_ix PLS_INTEGER := 0;
4058: l_new_row_idx PLS_INTEGER := 0;
4059: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1

Line 4066: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

4062: BEGIN
4063: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
4064: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
4065:
4066: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4067: SET CATEGORY_SET_NAME = NVL( mici.CATEGORY_SET_NAME,
4068: ( SELECT mcs.CATEGORY_SET_NAME
4069: FROM MTL_CATEGORY_SETS mcs
4070: WHERE mcs.CATEGORY_SET_ID = mici.CATEGORY_SET_ID

Line 4085: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

4081: )
4082: AND SET_PROCESS_ID = p_batch_id
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)

Line 4247: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE

4243: IF l_merged_rows IS NOT NULL THEN
4244: -- delete
4245: Debug_Conc_Log( l_proc_log_prefix || 'Deleting ' || l_old_rowids.COUNT || ' old rows ...' );
4246: FORALL rid_ix IN INDICES OF l_old_rowids
4247: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE
4248: WHERE ROWID = l_old_rowids( rid_ix );
4249: -- insert
4250: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
4251: FORALL row_index IN INDICES OF l_merged_rows

Line 4252: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE

4248: WHERE ROWID = l_old_rowids( rid_ix );
4249: -- insert
4250: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
4251: FORALL row_index IN INDICES OF l_merged_rows
4252: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE
4253: VALUES l_merged_rows( row_index );
4254: END IF;
4255: END IF; -- ENDS IF l_old_rows.count <> 0
4256: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 4959: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

4955: AND PROCESS_FLAG = 111;
4956:
4957: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Revisions.' );
4958: -- processing category assignments
4959: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4960: SET (PROCESS_FLAG, INVENTORY_ITEM_ID) =
4961: (SELECT PROCESS_FLAG, INVENTORY_ITEM_ID
4962: FROM MTL_ITEM_CATEGORIES_INTERFACE mici_merged
4963: WHERE mici_merged.ITEM_NUMBER = mici.ITEM_NUMBER

Line 4962: FROM MTL_ITEM_CATEGORIES_INTERFACE mici_merged

4958: -- processing category assignments
4959: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4960: SET (PROCESS_FLAG, INVENTORY_ITEM_ID) =
4961: (SELECT PROCESS_FLAG, INVENTORY_ITEM_ID
4962: FROM MTL_ITEM_CATEGORIES_INTERFACE mici_merged
4963: WHERE mici_merged.ITEM_NUMBER = mici.ITEM_NUMBER
4964: AND mici_merged.ORGANIZATION_ID = mici.ORGANIZATION_ID
4965: AND mici_merged.CATEGORY_SET_NAME = mici.CATEGORY_SET_NAME
4966: AND mici_merged.CATEGORY_NAME = mici.CATEGORY_NAME

Line 6491: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

6487: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND
6488: ORGANIZATION_ID IS NULL;
6489:
6490:
6491: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
6492: SET ORGANIZATION_ID =
6493: CASE
6494: WHEN ORGANIZATION_CODE IS NOT NULL
6495: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MICI.ORGANIZATION_CODE)

Line 6691: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

6687: AND PROCESS_FLAG = 1
6688: AND ITEM_NUMBER IS NULL
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)

Line 6852: --R12C: Insertion of Fake row into MSII for a orphan row in MTL_ITEM_CATEGORIES_INTERFACE

6848: )
6849: GROUP BY EIAI.ITEM_NUMBER, EIAI.organization_id;
6850: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, parent rows inserted for ASSOCIATIONS: ' || SQL%ROWCOUNT );
6851:
6852: --R12C: Insertion of Fake row into MSII for a orphan row in MTL_ITEM_CATEGORIES_INTERFACE
6853: INSERT INTO
6854: MTL_SYSTEM_ITEMS_INTERFACE MSII
6855: ( transaction_type, process_flag, set_process_id, organization_id, source_system_id
6856: , confirm_status, inventory_item_id, item_number

Line 6867: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI

6863: , l_insert_date -- LAST_UPDATE_DATE
6864: , MAX( MICI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6865: , MAX( MICI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6866: , MAX( MICI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6867: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI
6868: WHERE
6869: set_process_id = p_data_set_id
6870: AND process_flag = 1
6871: AND MICI.organization_id = l_org_id

Line 6936: UPDATE MTL_ITEM_CATEGORIES_INTERFACE

6932: SET PROCESS_FLAG = 0
6933: WHERE SET_PROCESS_ID = p_data_set_id AND
6934: PROCESS_FLAG IS NULL;
6935:
6936: UPDATE MTL_ITEM_CATEGORIES_INTERFACE
6937: SET PROCESS_FLAG = 0
6938: WHERE SET_PROCESS_ID = p_data_set_id AND
6939: PROCESS_FLAG IS NULL;
6940:

Line 7098: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI

7094: , l_insert_date -- LAST_UPDATE_DATE
7095: , MAX( MICI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
7096: , MAX( MICI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
7097: , MAX( MICI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
7098: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI
7099: WHERE
7100: MICI.set_process_id = p_data_set_id
7101: AND MICI.process_flag = 0
7102: AND MICI.organization_id = l_org_id

Line 7867: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.

7863:
7864: /*
7865: * This method populates the child entities with PK values.
7866: * This method populates the other interface tables like MTL_ITEM_REVISION_INTERFACE,
7867: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.
7868: * with the inventory item id/number and organization id/code.
7869: */
7870: PROCEDURE Resolve_Child_Entities( p_data_set_id IN NUMBER
7871: , p_commit IN FLAG DEFAULT FND_API.G_TRUE

Line 8612: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

8608: AND MSII.ORGANIZATION_ID = l_org_id);
8609:
8610: Debug_Conc_Log('Resolve_Child_Entities - After resolving revision rows' );
8611: -- updating item_number, item_id from MSII table
8612: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
8613: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER) =
8614: (SELECT
8615: 1,
8616: (CASE

Line 9041: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

9037: END IF;
9038:
9039: -- updating the item category assignments
9040: l_sql := q'#
9041: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
9042: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
9043: (SELECT
9044: 1,
9045: MICI.TRANSACTION_TYPE,

Line 9546: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

9542: );
9543: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9544:
9545: -- updating item category assignments
9546: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
9547: SET PROCESS_FLAG = 1
9548: WHERE ( INVENTORY_ITEM_ID = l_item_id
9549: OR ( ITEM_NUMBER = l_item_number
9550: AND INVENTORY_ITEM_ID IS NULL

Line 9657: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

9653: );
9654: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9655:
9656: -- updating item category assignments
9657: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
9658: SET PROCESS_FLAG = 1
9659: WHERE ITEM_NUMBER = l_item_number
9660: AND PROCESS_FLAG = 3
9661: AND SET_PROCESS_ID = p_batch_id

Line 9917: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici

9913: );
9914: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9915:
9916: -- updating item category assignments
9917: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
9918: SET PROCESS_FLAG = 1
9919: WHERE SOURCE_SYSTEM_ID = l_ss_id
9920: AND SOURCE_SYSTEM_REFERENCE = l_ssr
9921: AND PROCESS_FLAG = 3

Line 12555: FROM MTL_ITEM_CATEGORIES_INTERFACE mici

12551: THEN 1
12552: ELSE NULL
12553: END
12554: ) UPDATE_CNT
12555: FROM MTL_ITEM_CATEGORIES_INTERFACE mici
12556: WHERE mici.SET_PROCESS_ID = p_set_process_id
12557: AND EXISTS
12558: (
12559: SELECT NULL