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_REVISIONS_INTERFACE

Line 113: FROM MTL_ITEM_REVISIONS_INTERFACE

109: SELECT
110: ORGANIZATION_ID,
111: TRANSACTION_ID,
112: PROCESS_FLAG
113: FROM MTL_ITEM_REVISIONS_INTERFACE
114: WHERE SET_PROCESS_ID = p_data_set_id
115: AND PROCESS_FLAG IN (33379, 33389);
116:
117: CURSOR c_ssxref_null_mici IS

Line 182: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

178: )
179: );
180:
181: -- MIRI
182: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
183: SET PROCESS_FLAG = (CASE WHEN MIRI.SOURCE_SYSTEM_REFERENCE IS NULL THEN 33379 ELSE 33389 END),
184: TRANSACTION_ID = NVL(TRANSACTION_ID, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
185: PROGRAM_APPLICATION_ID = l_prog_appid,
186: PROGRAM_ID = l_prog_id,

Line 338: ,'MTL_ITEM_REVISIONS_INTERFACE'

334: ,l_request_id
335: ,i.TRANSACTION_ID
336: ,l_msg_text
337: ,'SOURCE_SYSTEM_REFERENCE'
338: ,'MTL_ITEM_REVISIONS_INTERFACE'
339: ,'INV_IOI_ERR_SSXREF_IS_NULL_02'--bug 11894684, replace INV_IOI_ERR
340: ,l_err_text);
341: ELSIF i.PROCESS_FLAG = 33389 THEN
342: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

Line 354: ,'MTL_ITEM_REVISIONS_INTERFACE'

350: ,l_request_id
351: ,i.TRANSACTION_ID
352: ,l_msg_text
353: ,'SOURCE_SYSTEM_ID'
354: ,'MTL_ITEM_REVISIONS_INTERFACE'
355: ,'INV_IOI_ERR_SSXID_INVALID_02'--bug 11894684, replace INV_IOI_ERR
356: ,l_err_text);
357: END IF;
358: END LOOP;

Line 553: UPDATE MTL_ITEM_REVISIONS_INTERFACE

549: SET PROCESS_FLAG =3
550: WHERE PROCESS_FLAG IN (33379, 33389)
551: AND SET_PROCESS_ID = p_data_set_id;
552:
553: UPDATE MTL_ITEM_REVISIONS_INTERFACE
554: SET PROCESS_FLAG =3
555: WHERE PROCESS_FLAG IN (33379, 33389)
556: AND SET_PROCESS_ID = p_data_set_id;
557:

Line 658: -- checking whether stats needs to be collected on MTL_ITEM_REVISIONS_INTERFACE

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

Line 660: FROM MTL_ITEM_REVISIONS_INTERFACE

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

Line 664: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');

660: FROM MTL_ITEM_REVISIONS_INTERFACE
661: WHERE SET_PROCESS_ID = p_data_set_id;
662:
663: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
664: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
665: Debug_Conc_Log('Collected Statistics on MTL_ITEM_REVISIONS_INTERFACE');
666: END IF;
667: */
668: -- Bug 12669090 : End

Line 665: Debug_Conc_Log('Collected Statistics on MTL_ITEM_REVISIONS_INTERFACE');

661: WHERE SET_PROCESS_ID = p_data_set_id;
662:
663: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
664: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
665: Debug_Conc_Log('Collected Statistics on MTL_ITEM_REVISIONS_INTERFACE');
666: END IF;
667: */
668: -- Bug 12669090 : End
669:

Line 2492: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;

2488: , p_master_org_id IN NUMBER DEFAULT NULL
2489: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
2490: )
2491: IS
2492: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;
2493: TYPE MIRI_ROWS IS TABLE OF MIRI_ROW INDEX BY BINARY_INTEGER;
2494:
2495: /*
2496: * Note that the organization_id column is filled in from the organization_code and batch organization_id

Line 2500: CURSOR c_ss_target_revs( cp_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE

2496: * Note that the organization_id column is filled in from the organization_code and batch organization_id
2497: * as part of resolve_ssxref_on_data_load
2498: * revision column is filled in from the revision_id before this cursor is fetched.
2499: */
2500: CURSOR c_ss_target_revs( cp_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
2501: , cp_master_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE ) IS
2502: SELECT
2503: rowid rid
2504: , FIRST_VALUE( ROWID ) OVER ( PARTITION BY

Line 2501: , cp_master_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE ) IS

2497: * as part of resolve_ssxref_on_data_load
2498: * revision column is filled in from the revision_id before this cursor is fetched.
2499: */
2500: CURSOR c_ss_target_revs( cp_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
2501: , cp_master_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE ) IS
2502: SELECT
2503: rowid rid
2504: , FIRST_VALUE( ROWID ) OVER ( PARTITION BY
2505: source_system_id

Line 2533: FROM mtl_item_revisions_interface miri

2529: , revision
2530: )
2531: cnt
2532: , miri.*
2533: FROM mtl_item_revisions_interface miri
2534: WHERE PROCESS_FLAG = 0
2535: and SET_PROCESS_ID = p_batch_id
2536: and SOURCE_SYSTEM_ID = cp_ss_id
2537: and SOURCE_SYSTEM_REFERENCE IS NOT NULL

Line 2549: CURSOR c_pdh_target_revs( cp_master_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE ) IS

2545: sub
2546: WHERE sub.cnt > 1
2547: ORDER BY master_rid, local_rank;
2548:
2549: CURSOR c_pdh_target_revs( cp_master_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE ) IS
2550: SELECT
2551: rowid rid
2552: , first_value( rowid ) over ( PARTITION BY
2553: item_number

Line 2578: FROM MTL_ITEM_REVISIONS_INTERFACE miri

2574: , revision
2575: )
2576: cnt
2577: , miri.*
2578: FROM MTL_ITEM_REVISIONS_INTERFACE miri
2579: WHERE PROCESS_FLAG = 1
2580: AND SET_PROCESS_ID = p_batch_id
2581: AND ITEM_NUMBER IS NOT NULL
2582: AND ORGANIZATION_ID IS NOT NULL

Line 2603: l_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE := p_ss_id;

2599: l_merge_base MIRI_ROW;
2600: l_old_rows TARGET_ROWS;
2601: l_old_rowids UROWID_TABLE;
2602:
2603: l_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
2604: l_ssr MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;
2605: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;
2606:
2607: l_cur_master_rid UROWID := NULL;

Line 2604: l_ssr MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;

2600: l_old_rows TARGET_ROWS;
2601: l_old_rowids UROWID_TABLE;
2602:
2603: l_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
2604: l_ssr MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;
2605: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;
2606:
2607: l_cur_master_rid UROWID := NULL;
2608: l_mrow_ix PLS_INTEGER := 0;

Line 2605: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;

2601: l_old_rowids UROWID_TABLE;
2602:
2603: l_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
2604: l_ssr MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;
2605: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;
2606:
2607: l_cur_master_rid UROWID := NULL;
2608: l_mrow_ix PLS_INTEGER := 0;
2609: l_is_pdh_batch BOOLEAN;

Line 2611: l_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE := p_master_org_id;

2607: l_cur_master_rid UROWID := NULL;
2608: l_mrow_ix PLS_INTEGER := 0;
2609: l_is_pdh_batch BOOLEAN;
2610:
2611: l_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE := p_master_org_id;
2612: l_pdh_batch_flag FLAG := p_is_pdh_batch;
2613:
2614: l_proc_log_prefix CONSTANT VARCHAR2(30) := 'merge_revs - ';
2615: BEGIN

Line 2629: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

2625: Debug_Conc_Log( l_proc_log_prefix || 'Master Org ID: ' || l_org_id );
2626: Debug_Conc_Log( l_proc_log_prefix || 'SS ID: ' || l_ss_id );
2627: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: ' || l_pdh_batch_flag );
2628:
2629: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
2630: SET REVISION = NVL( ( SELECT r.REVISION
2631: FROM MTL_ITEM_REVISIONS_B r
2632: WHERE r.REVISION_ID = miri.REVISION_ID
2633: AND r.ORGANIZATION_ID = miri.ORGANIZATION_ID

Line 2724: WHERE TABLE_NAME = 'MTL_ITEM_REVISIONS_INTERFACE'

2720: /* Generated using:
2721: SET LINESIZE 200
2722: SELECT 'if l_merged_rows( l_mrow_ix ).' ||column_name || ' is null then l_merged_rows( l_mrow_ix ).' || column_name || ' := l_old_rows( orow_ix ).' || column_name || '; end if; '
2723: FROM ALL_TAB_COLUMNS
2724: WHERE TABLE_NAME = 'MTL_ITEM_REVISIONS_INTERFACE'
2725: AND COLUMN_NAME NOT IN
2726: ( -- special cases (for merge)
2727: 'INVENTORY_ITEM_ID'
2728: , 'ITEM_NUMBER'

Line 2797: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE

2793: IF l_merged_rows IS NOT NULL THEN
2794: -- delete
2795: Debug_Conc_Log( l_proc_log_prefix || 'Deleting ' || l_old_rowids.COUNT || ' old rows ...' );
2796: FORALL rid_ix IN INDICES OF l_old_rowids
2797: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE
2798: WHERE ROWID = l_old_rowids( rid_ix );
2799: -- insert
2800: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
2801: FORALL row_index IN INDICES OF l_merged_rows

Line 2802: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE

2798: WHERE ROWID = l_old_rowids( rid_ix );
2799: -- insert
2800: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
2801: FORALL row_index IN INDICES OF l_merged_rows
2802: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE
2803: VALUES l_merged_rows( row_index );
2804: END IF;
2805: END IF; -- ENDS IF l_old_rows.count <> 0
2806: IF p_commit = FND_API.G_TRUE THEN

Line 3812: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;

3808: PROCEDURE Merge_Revs_For_Import( p_batch_id IN NUMBER
3809: , p_master_org_id IN NUMBER
3810: )
3811: IS
3812: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;
3813: TYPE MIRI_ROWS IS TABLE OF MIRI_ROW INDEX BY BINARY_INTEGER;
3814:
3815: /*
3816: * Note that the organization_id column is filled in from the organization_code and batch organization_id

Line 3828: FROM MTL_ITEM_REVISIONS_INTERFACE miri

3824: ROWID rid,
3825: COUNT( * ) OVER ( PARTITION BY ITEM_NUMBER, ORGANIZATION_ID, REVISION ) cnt,
3826: RANK() OVER ( ORDER BY ITEM_NUMBER, ORGANIZATION_ID, REVISION ) rnk,
3827: miri.*
3828: FROM MTL_ITEM_REVISIONS_INTERFACE miri
3829: WHERE PROCESS_FLAG = 1
3830: AND SET_PROCESS_ID = p_batch_id
3831: AND ITEM_NUMBER IS NOT NULL
3832: AND ORGANIZATION_ID IS NOT NULL

Line 3852: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;

3848: l_merged_row MIRI_ROW;
3849: l_old_rows TARGET_ROWS;
3850: l_old_rowids UROWID_TABLE;
3851:
3852: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;
3853:
3854: l_mrow_ix PLS_INTEGER := 0;
3855: l_new_row_idx PLS_INTEGER := 0;
3856: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1

Line 3863: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

3859: BEGIN
3860: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
3861: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
3862:
3863: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
3864: SET REVISION = NVL( ( SELECT r.REVISION
3865: FROM MTL_ITEM_REVISIONS_B r
3866: WHERE r.REVISION_ID = miri.REVISION_ID
3867: AND r.ORGANIZATION_ID = miri.ORGANIZATION_ID

Line 3876: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

3872: AND SET_PROCESS_ID = p_batch_id
3873: AND PROCESS_FLAG = 1
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)

Line 4054: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE

4050: IF l_merged_rows IS NOT NULL THEN
4051: -- delete
4052: Debug_Conc_Log( l_proc_log_prefix || 'Deleting ' || l_old_rowids.COUNT || ' old rows ...' );
4053: FORALL rid_ix IN INDICES OF l_old_rowids
4054: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE
4055: WHERE ROWID = l_old_rowids( rid_ix );
4056: -- insert
4057: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
4058: FORALL row_index IN INDICES OF l_merged_rows

Line 4059: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE

4055: WHERE ROWID = l_old_rowids( rid_ix );
4056: -- insert
4057: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
4058: FORALL row_index IN INDICES OF l_merged_rows
4059: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE
4060: VALUES l_merged_rows( row_index );
4061: END IF;
4062: END IF; -- ENDS IF l_old_rows.count <> 0
4063: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 5009: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

5005: AND PROCESS_FLAG = 111;
5006:
5007: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Items.' );
5008: -- processing item revisions
5009: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
5010: SET (PROCESS_FLAG, INVENTORY_ITEM_ID) =
5011: (SELECT PROCESS_FLAG, INVENTORY_ITEM_ID
5012: FROM MTL_ITEM_REVISIONS_INTERFACE miri_merged
5013: WHERE miri_merged.ITEM_NUMBER = miri.ITEM_NUMBER

Line 5012: FROM MTL_ITEM_REVISIONS_INTERFACE miri_merged

5008: -- processing item revisions
5009: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
5010: SET (PROCESS_FLAG, INVENTORY_ITEM_ID) =
5011: (SELECT PROCESS_FLAG, INVENTORY_ITEM_ID
5012: FROM MTL_ITEM_REVISIONS_INTERFACE miri_merged
5013: WHERE miri_merged.ITEM_NUMBER = miri.ITEM_NUMBER
5014: AND miri_merged.ORGANIZATION_ID = miri.ORGANIZATION_ID
5015: AND miri_merged.REVISION = miri.REVISION
5016: AND miri_merged.REQUEST_ID = miri.REQUEST_ID

Line 6103: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

6099: RETURN false;
6100: END IF;
6101:
6102: SELECT 'x' INTO l_temp
6103: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
6104: WHERE SET_PROCESS_ID = p_batch_id AND
6105: PROCESS_FLAG = 0 AND
6106: SOURCE_SYSTEM_ID = p_source_system_id AND
6107: SOURCE_SYSTEM_REFERENCE = p_source_system_reference AND

Line 6561: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

6557: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND
6558: ORGANIZATION_ID IS NULL;
6559:
6560:
6561: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
6562: SET ORGANIZATION_ID =
6563: CASE
6564: WHEN ORGANIZATION_CODE IS NOT NULL
6565: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MIRI.ORGANIZATION_CODE)

Line 6766: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

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

Line 7016: UPDATE MTL_ITEM_REVISIONS_INTERFACE

7012: SET PROCESS_FLAG = 0
7013: WHERE SET_PROCESS_ID = p_data_set_id AND
7014: PROCESS_FLAG IS NULL;
7015:
7016: UPDATE MTL_ITEM_REVISIONS_INTERFACE
7017: SET PROCESS_FLAG = 0
7018: WHERE SET_PROCESS_ID = p_data_set_id AND
7019: PROCESS_FLAG IS NULL;
7020:

Line 7362: -- rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE: We set it to 'S' meaning specific.

7358: execute immediate l_sql using p_data_set_id, l_org_id;
7359: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, resolved xrefs. Rows touched: ' || SQL%ROWCOUNT );
7360: -- determine if import policy applies to a source system item:
7361: -- the revision import policy should not apply if the user has given us a
7362: -- rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE: We set it to 'S' meaning specific.
7363: -- however, if the rev import policy is set to Specific already, we need to verify that
7364: -- the user has given us a rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE.
7365: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
7366: SET REVISION_IMPORT_POLICY =

Line 7364: -- the user has given us a rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE.

7360: -- determine if import policy applies to a source system item:
7361: -- the revision import policy should not apply if the user has given us a
7362: -- rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE: We set it to 'S' meaning specific.
7363: -- however, if the rev import policy is set to Specific already, we need to verify that
7364: -- the user has given us a rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE.
7365: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
7366: SET REVISION_IMPORT_POLICY =
7367: CASE
7368: WHEN EXISTS -- check the revision interface table

Line 7371: FROM MTL_ITEM_REVISIONS_INTERFACE

7367: CASE
7368: WHEN EXISTS -- check the revision interface table
7369: (
7370: SELECT NULL
7371: FROM MTL_ITEM_REVISIONS_INTERFACE
7372: WHERE SET_PROCESS_ID = MSII.SET_PROCESS_ID
7373: AND SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
7374: AND SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
7375: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID

Line 8281: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

8277: END IF; --IF l_security_predicate IS NULL THEN
8278: END IF; --IF NVL(l_import_xref_only, 'N') = 'Y' THEN
8279:
8280: -- resolving transaction type for revisions
8281: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
8282: SET TRANSACTION_TYPE = (
8283: SELECT
8284: (CASE
8285: WHEN MSII.CONFIRM_STATUS = 'CN'

Line 8410: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

8406: CASE
8407: WHEN
8408: (NVL(MSII.REVISION_IMPORT_POLICY, l_import_policy) = 'N' AND
8409: 1 <> (SELECT COUNT(*)
8410: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
8411: WHERE MIRI.SET_PROCESS_ID = MSII.SET_PROCESS_ID
8412: AND MIRI.PROCESS_FLAG = 0
8413: AND MIRI.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8414: AND MIRI.SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE

Line 8434: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

8430: SET CONFIRM_STATUS = (
8431: CASE
8432: WHEN ( NVL(MSII.REVISION_IMPORT_POLICY, l_import_policy) = 'N' AND
8433: 1 <> (SELECT COUNT(*)
8434: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
8435: WHERE MIRI.SET_PROCESS_ID = MSII.SET_PROCESS_ID
8436: AND MIRI.PROCESS_FLAG = 0
8437: AND MIRI.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8438: AND MIRI.SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE

Line 8674: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

8670:
8671: Debug_Conc_Log('Resolve_Child_Entities - After resolving child items' );
8672:
8673: -- updating item_number, item_id from MSII table
8674: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
8675: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER) =
8676: (SELECT
8677: 1,
8678: (CASE

Line 8810: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

8806: WHERE INVENTORY_ITEM_ID = ATTRS.INVENTORY_ITEM_ID
8807: AND ORGANIZATION_ID = ATTRS.ORGANIZATION_ID)
8808: WHEN '2'
8809: THEN (SELECT REVISION
8810: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
8811: WHERE MIRI.SET_PROCESS_ID = ATTRS.DATA_SET_ID
8812: AND MIRI.SOURCE_SYSTEM_ID = ATTRS.SOURCE_SYSTEM_ID
8813: AND MIRI.SOURCE_SYSTEM_REFERENCE = ATTRS.SOURCE_SYSTEM_REFERENCE
8814: AND MIRI.ORGANIZATION_ID = ATTRS.ORGANIZATION_ID

Line 8847: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

8843: AND EXT.APPLICATION_ID = 431
8844: AND A.DATA_LEVEL = 'ITEM_REVISION_LEVEL');
8845:
8846: Debug_Conc_Log('Resolve_Child_Entities - After resolving user attrs intf table for revision' );
8847: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
8848: SET (REVISION, TRANSACTION_TYPE) =
8849: (SELECT
8850: (CASE
8851: WHEN (EXISTS (SELECT NULL

Line 9066: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

9062: Debug_Conc_Log('Resolve_Child_Entities - After updating items intf table for child items that has XXref' );
9063:
9064: -- updating the item revisions
9065: l_sql := q'#
9066: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
9067: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
9068: (SELECT
9069: 1,
9070: NVL(MIRI.TRANSACTION_TYPE, 'SYNC'),

Line 9109: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

9105: -- updating the item revisions where revision is null and revision_import_policy is Update Latest
9106: -- Bug: 5476972
9107: IF l_import_policy = 'L' THEN
9108: l_sql := q'#
9109: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
9110: SET (REVISION, TRANSACTION_TYPE) =
9111: (SELECT MAX(REVISION) KEEP (DENSE_RANK FIRST ORDER BY EFFECTIVITY_DATE DESC), 'UPDATE'
9112: FROM MTL_ITEM_REVISIONS_B
9113: WHERE INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID

Line 9632: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

9628: );
9629: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9630:
9631: -- updating item revisions
9632: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
9633: SET PROCESS_FLAG = 1
9634: WHERE ( INVENTORY_ITEM_ID = l_item_id
9635: OR ( ITEM_NUMBER = l_item_number
9636: AND INVENTORY_ITEM_ID IS NULL

Line 9747: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

9743: );
9744: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9745:
9746: -- updating item revisions
9747: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
9748: SET PROCESS_FLAG = 1
9749: WHERE ITEM_NUMBER = l_item_number
9750: AND PROCESS_FLAG = 3
9751: AND SET_PROCESS_ID = p_batch_id

Line 10006: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

10002: );
10003: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10004:
10005: -- updating item revisions
10006: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
10007: SET PROCESS_FLAG = 1
10008: WHERE SOURCE_SYSTEM_ID = l_ss_id
10009: AND SOURCE_SYSTEM_REFERENCE = l_ssr
10010: AND PROCESS_FLAG = 3

Line 10358: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE

10354: END GET_LATEST_EIUAI_REV_PDH;
10355:
10356: FUNCTION GET_LATEST_MIRI_REV_SS
10357: (
10358: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10359: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10360: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10361: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10359: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE

10355:
10356: FUNCTION GET_LATEST_MIRI_REV_SS
10357: (
10358: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10359: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10360: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10361: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10363: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

Line 10360: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE

10356: FUNCTION GET_LATEST_MIRI_REV_SS
10357: (
10358: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10359: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10360: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10361: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10363: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10364: )

Line 10361: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE

10357: (
10358: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10359: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10360: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10361: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10363: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10364: )
10365: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS

Line 10363: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

10359: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10360: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10361: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10363: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10364: )
10365: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10366: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10367: BEGIN

Line 10365: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS

10361: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10363: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10364: )
10365: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10366: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10367: BEGIN
10368: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10369: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )

Line 10366: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;

10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10363: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10364: )
10365: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10366: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10367: BEGIN
10368: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10369: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10370: INTO l_revision

Line 10372: MTL_ITEM_REVISIONS_INTERFACE MIRI

10368: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10369: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10370: INTO l_revision
10371: FROM
10372: MTL_ITEM_REVISIONS_INTERFACE MIRI
10373: WHERE MIRI.SET_PROCESS_id = p_batch_id
10374: AND MIRI.SOURCE_SYSTEM_ID = p_source_system_id
10375: AND MIRI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
10376: AND MIRI.ORGANIZATION_ID = p_organization_id

Line 10382: MTL_ITEM_REVISIONS_INTERFACE MIRI

10378: ELSE
10379: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10380: INTO l_revision
10381: FROM
10382: MTL_ITEM_REVISIONS_INTERFACE MIRI
10383: WHERE
10384: MIRI.SET_PROCESS_id = p_batch_id
10385: AND MIRI.SOURCE_SYSTEM_ID = p_source_system_id
10386: AND MIRI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference

Line 10399: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE

10395: END GET_LATEST_MIRI_REV_SS;
10396:
10397: FUNCTION GET_LATEST_MIRI_REV_PDH
10398: (
10399: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10400: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10401: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10402: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10400: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE

10396:
10397: FUNCTION GET_LATEST_MIRI_REV_PDH
10398: (
10399: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10400: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10401: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10402: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10404: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

Line 10401: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE

10397: FUNCTION GET_LATEST_MIRI_REV_PDH
10398: (
10399: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10400: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10401: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10402: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10404: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10405: )

Line 10402: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE

10398: (
10399: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10400: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10401: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10402: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10404: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10405: )
10406: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS

Line 10404: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

10400: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10401: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10402: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10404: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10405: )
10406: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10407: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10408: BEGIN

Line 10406: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS

10402: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10404: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10405: )
10406: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10407: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10408: BEGIN
10409: IF p_inventory_item_id IS NULL THEN
10410: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN

Line 10407: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;

10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10404: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10405: )
10406: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10407: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10408: BEGIN
10409: IF p_inventory_item_id IS NULL THEN
10410: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10411: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST

Line 10414: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

10410: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10411: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10412: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10413: INTO l_revision
10414: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
10415: WHERE MIRI.SET_PROCESS_id = p_batch_id
10416: AND MIRI.ITEM_NUMBER = p_item_number
10417: AND MIRI.ORGANIZATION_ID = p_organization_id
10418: AND MIRI.PROCESS_FLAG = 1;

Line 10423: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

10419: ELSE
10420: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10421: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10422: INTO l_revision
10423: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
10424: WHERE MIRI.SET_PROCESS_id = p_batch_id
10425: AND MIRI.ITEM_NUMBER = p_item_number
10426: AND MIRI.ORGANIZATION_ID = p_organization_id
10427: AND MIRI.REQUEST_ID = p_request_id

Line 10435: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

10431: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10432: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10433: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10434: INTO l_revision
10435: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
10436: WHERE MIRI.SET_PROCESS_id = p_batch_id
10437: AND ( ( MIRI.INVENTORY_ITEM_ID IS NULL AND MIRI.ITEM_NUMBER = p_item_number )
10438: OR MIRI.INVENTORY_ITEM_ID = p_inventory_item_id
10439: )

Line 10446: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

10442: ELSE
10443: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10444: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10445: INTO l_revision
10446: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
10447: WHERE MIRI.SET_PROCESS_id = p_batch_id
10448: AND ( ( MIRI.INVENTORY_ITEM_ID IS NULL AND MIRI.ITEM_NUMBER = p_item_number )
10449: OR MIRI.INVENTORY_ITEM_ID = p_inventory_item_id
10450: )

Line 12570: FROM MTL_ITEM_REVISIONS_INTERFACE miri

12566: THEN 1
12567: ELSE NULL
12568: END
12569: ) UPDATE_CNT
12570: FROM MTL_ITEM_REVISIONS_INTERFACE miri
12571: WHERE SET_PROCESS_ID = p_set_process_id
12572: AND EXISTS
12573: (
12574: SELECT NULL