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'
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'
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 650: -- checking whether stats needs to be collected on MTL_ITEM_REVISIONS_INTERFACE

646: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
647: Debug_Conc_Log('Collected Statistics on MTL_SYSTEM_ITEMS_INTERFACE');
648: END IF;
649:
650: -- checking whether stats needs to be collected on MTL_ITEM_REVISIONS_INTERFACE
651: SELECT COUNT(1) INTO l_records
652: FROM MTL_ITEM_REVISIONS_INTERFACE
653: WHERE SET_PROCESS_ID = p_data_set_id;
654:

Line 652: FROM MTL_ITEM_REVISIONS_INTERFACE

648: END IF;
649:
650: -- checking whether stats needs to be collected on MTL_ITEM_REVISIONS_INTERFACE
651: SELECT COUNT(1) INTO l_records
652: FROM MTL_ITEM_REVISIONS_INTERFACE
653: WHERE SET_PROCESS_ID = p_data_set_id;
654:
655: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
656: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');

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

652: FROM MTL_ITEM_REVISIONS_INTERFACE
653: WHERE SET_PROCESS_ID = p_data_set_id;
654:
655: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
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

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

653: WHERE SET_PROCESS_ID = p_data_set_id;
654:
655: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
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

Line 2432: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;

2428: , p_master_org_id IN NUMBER DEFAULT NULL
2429: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
2430: )
2431: IS
2432: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;
2433: TYPE MIRI_ROWS IS TABLE OF MIRI_ROW INDEX BY BINARY_INTEGER;
2434:
2435: /*
2436: * Note that the organization_id column is filled in from the organization_code and batch organization_id

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

2436: * Note that the organization_id column is filled in from the organization_code and batch organization_id
2437: * as part of resolve_ssxref_on_data_load
2438: * revision column is filled in from the revision_id before this cursor is fetched.
2439: */
2440: CURSOR c_ss_target_revs( cp_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
2441: , cp_master_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE ) IS
2442: SELECT
2443: rowid rid
2444: , FIRST_VALUE( ROWID ) OVER ( PARTITION BY

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

2437: * as part of resolve_ssxref_on_data_load
2438: * revision column is filled in from the revision_id before this cursor is fetched.
2439: */
2440: CURSOR c_ss_target_revs( cp_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
2441: , cp_master_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE ) IS
2442: SELECT
2443: rowid rid
2444: , FIRST_VALUE( ROWID ) OVER ( PARTITION BY
2445: source_system_id

Line 2473: FROM mtl_item_revisions_interface miri

2469: , revision
2470: )
2471: cnt
2472: , miri.*
2473: FROM mtl_item_revisions_interface miri
2474: WHERE PROCESS_FLAG = 0
2475: and SET_PROCESS_ID = p_batch_id
2476: and SOURCE_SYSTEM_ID = cp_ss_id
2477: and SOURCE_SYSTEM_REFERENCE IS NOT NULL

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

2485: sub
2486: WHERE sub.cnt > 1
2487: ORDER BY master_rid, local_rank;
2488:
2489: CURSOR c_pdh_target_revs( cp_master_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE ) IS
2490: SELECT
2491: rowid rid
2492: , first_value( rowid ) over ( PARTITION BY
2493: item_number

Line 2518: FROM MTL_ITEM_REVISIONS_INTERFACE miri

2514: , revision
2515: )
2516: cnt
2517: , miri.*
2518: FROM MTL_ITEM_REVISIONS_INTERFACE miri
2519: WHERE PROCESS_FLAG = 1
2520: AND SET_PROCESS_ID = p_batch_id
2521: AND ITEM_NUMBER IS NOT NULL
2522: AND ORGANIZATION_ID IS NOT NULL

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

2539: l_merge_base MIRI_ROW;
2540: l_old_rows TARGET_ROWS;
2541: l_old_rowids UROWID_TABLE;
2542:
2543: l_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
2544: l_ssr MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;
2545: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;
2546:
2547: l_cur_master_rid UROWID := NULL;

Line 2544: l_ssr MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;

2540: l_old_rows TARGET_ROWS;
2541: l_old_rowids UROWID_TABLE;
2542:
2543: l_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
2544: l_ssr MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;
2545: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;
2546:
2547: l_cur_master_rid UROWID := NULL;
2548: l_mrow_ix PLS_INTEGER := 0;

Line 2545: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;

2541: l_old_rowids UROWID_TABLE;
2542:
2543: l_ss_id MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
2544: l_ssr MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;
2545: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;
2546:
2547: l_cur_master_rid UROWID := NULL;
2548: l_mrow_ix PLS_INTEGER := 0;
2549: l_is_pdh_batch BOOLEAN;

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

2547: l_cur_master_rid UROWID := NULL;
2548: l_mrow_ix PLS_INTEGER := 0;
2549: l_is_pdh_batch BOOLEAN;
2550:
2551: l_org_id MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE := p_master_org_id;
2552: l_pdh_batch_flag FLAG := p_is_pdh_batch;
2553:
2554: l_proc_log_prefix CONSTANT VARCHAR2(30) := 'merge_revs - ';
2555: BEGIN

Line 2569: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

2565: Debug_Conc_Log( l_proc_log_prefix || 'Master Org ID: ' || l_org_id );
2566: Debug_Conc_Log( l_proc_log_prefix || 'SS ID: ' || l_ss_id );
2567: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: ' || l_pdh_batch_flag );
2568:
2569: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
2570: SET REVISION = NVL( ( SELECT r.REVISION
2571: FROM MTL_ITEM_REVISIONS_B r
2572: WHERE r.REVISION_ID = miri.REVISION_ID
2573: AND r.ORGANIZATION_ID = miri.ORGANIZATION_ID

Line 2664: WHERE TABLE_NAME = 'MTL_ITEM_REVISIONS_INTERFACE'

2660: /* Generated using:
2661: SET LINESIZE 200
2662: 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; '
2663: FROM ALL_TAB_COLUMNS
2664: WHERE TABLE_NAME = 'MTL_ITEM_REVISIONS_INTERFACE'
2665: AND COLUMN_NAME NOT IN
2666: ( -- special cases (for merge)
2667: 'INVENTORY_ITEM_ID'
2668: , 'ITEM_NUMBER'

Line 2737: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE

2733: IF l_merged_rows IS NOT NULL THEN
2734: -- delete
2735: Debug_Conc_Log( l_proc_log_prefix || 'Deleting ' || l_old_rowids.COUNT || ' old rows ...' );
2736: FORALL rid_ix IN INDICES OF l_old_rowids
2737: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE
2738: WHERE ROWID = l_old_rowids( rid_ix );
2739: -- insert
2740: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
2741: FORALL row_index IN INDICES OF l_merged_rows

Line 2742: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE

2738: WHERE ROWID = l_old_rowids( rid_ix );
2739: -- insert
2740: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
2741: FORALL row_index IN INDICES OF l_merged_rows
2742: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE
2743: VALUES l_merged_rows( row_index );
2744: END IF;
2745: END IF; -- ENDS IF l_old_rows.count <> 0
2746: IF p_commit = FND_API.G_TRUE THEN

Line 3750: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;

3746: PROCEDURE Merge_Revs_For_Import( p_batch_id IN NUMBER
3747: , p_master_org_id IN NUMBER
3748: )
3749: IS
3750: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;
3751: TYPE MIRI_ROWS IS TABLE OF MIRI_ROW INDEX BY BINARY_INTEGER;
3752:
3753: /*
3754: * Note that the organization_id column is filled in from the organization_code and batch organization_id

Line 3766: FROM MTL_ITEM_REVISIONS_INTERFACE miri

3762: ROWID rid,
3763: COUNT( * ) OVER ( PARTITION BY ITEM_NUMBER, ORGANIZATION_ID, REVISION ) cnt,
3764: RANK() OVER ( ORDER BY ITEM_NUMBER, ORGANIZATION_ID, REVISION ) rnk,
3765: miri.*
3766: FROM MTL_ITEM_REVISIONS_INTERFACE miri
3767: WHERE PROCESS_FLAG = 1
3768: AND SET_PROCESS_ID = p_batch_id
3769: AND ITEM_NUMBER IS NOT NULL
3770: AND ORGANIZATION_ID IS NOT NULL

Line 3790: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;

3786: l_merged_row MIRI_ROW;
3787: l_old_rows TARGET_ROWS;
3788: l_old_rowids UROWID_TABLE;
3789:
3790: l_candidate_trans MTL_ITEM_REVISIONS_INTERFACE.TRANSACTION_TYPE%TYPE;
3791:
3792: l_mrow_ix PLS_INTEGER := 0;
3793: l_new_row_idx PLS_INTEGER := 0;
3794: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1

Line 3801: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

3797: BEGIN
3798: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
3799: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
3800:
3801: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
3802: SET REVISION = NVL( ( SELECT r.REVISION
3803: FROM MTL_ITEM_REVISIONS_B r
3804: WHERE r.REVISION_ID = miri.REVISION_ID
3805: AND r.ORGANIZATION_ID = miri.ORGANIZATION_ID

Line 3814: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

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

Line 3992: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE

3988: IF l_merged_rows IS NOT NULL THEN
3989: -- delete
3990: Debug_Conc_Log( l_proc_log_prefix || 'Deleting ' || l_old_rowids.COUNT || ' old rows ...' );
3991: FORALL rid_ix IN INDICES OF l_old_rowids
3992: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE
3993: WHERE ROWID = l_old_rowids( rid_ix );
3994: -- insert
3995: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
3996: FORALL row_index IN INDICES OF l_merged_rows

Line 3997: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE

3993: WHERE ROWID = l_old_rowids( rid_ix );
3994: -- insert
3995: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
3996: FORALL row_index IN INDICES OF l_merged_rows
3997: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE
3998: VALUES l_merged_rows( row_index );
3999: END IF;
4000: END IF; -- ENDS IF l_old_rows.count <> 0
4001: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 4944: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

4940: AND PROCESS_FLAG = 111;
4941:
4942: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Items.' );
4943: -- processing item revisions
4944: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
4945: SET (PROCESS_FLAG, INVENTORY_ITEM_ID) =
4946: (SELECT PROCESS_FLAG, INVENTORY_ITEM_ID
4947: FROM MTL_ITEM_REVISIONS_INTERFACE miri_merged
4948: WHERE miri_merged.ITEM_NUMBER = miri.ITEM_NUMBER

Line 4947: FROM MTL_ITEM_REVISIONS_INTERFACE miri_merged

4943: -- processing item revisions
4944: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
4945: SET (PROCESS_FLAG, INVENTORY_ITEM_ID) =
4946: (SELECT PROCESS_FLAG, INVENTORY_ITEM_ID
4947: FROM MTL_ITEM_REVISIONS_INTERFACE miri_merged
4948: WHERE miri_merged.ITEM_NUMBER = miri.ITEM_NUMBER
4949: AND miri_merged.ORGANIZATION_ID = miri.ORGANIZATION_ID
4950: AND miri_merged.REVISION = miri.REVISION
4951: AND miri_merged.REQUEST_ID = miri.REQUEST_ID

Line 6021: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

6017: RETURN false;
6018: END IF;
6019:
6020: SELECT 'x' INTO l_temp
6021: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
6022: WHERE SET_PROCESS_ID = p_batch_id AND
6023: PROCESS_FLAG = 0 AND
6024: SOURCE_SYSTEM_ID = p_source_system_id AND
6025: SOURCE_SYSTEM_REFERENCE = p_source_system_reference AND

Line 6479: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

6475: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND
6476: ORGANIZATION_ID IS NULL;
6477:
6478:
6479: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
6480: SET ORGANIZATION_ID =
6481: CASE
6482: WHEN ORGANIZATION_CODE IS NOT NULL
6483: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MIRI.ORGANIZATION_CODE)

Line 6681: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

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

Line 6931: UPDATE MTL_ITEM_REVISIONS_INTERFACE

6927: SET PROCESS_FLAG = 0
6928: WHERE SET_PROCESS_ID = p_data_set_id AND
6929: PROCESS_FLAG IS NULL;
6930:
6931: UPDATE MTL_ITEM_REVISIONS_INTERFACE
6932: SET PROCESS_FLAG = 0
6933: WHERE SET_PROCESS_ID = p_data_set_id AND
6934: PROCESS_FLAG IS NULL;
6935:

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

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

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

7266: -- determine if import policy applies to a source system item:
7267: -- the revision import policy should not apply if the user has given us a
7268: -- rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE: We set it to 'S' meaning specific.
7269: -- however, if the rev import policy is set to Specific already, we need to verify that
7270: -- the user has given us a rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE.
7271: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
7272: SET REVISION_IMPORT_POLICY =
7273: CASE
7274: WHEN EXISTS -- check the revision interface table

Line 7277: FROM MTL_ITEM_REVISIONS_INTERFACE

7273: CASE
7274: WHEN EXISTS -- check the revision interface table
7275: (
7276: SELECT NULL
7277: FROM MTL_ITEM_REVISIONS_INTERFACE
7278: WHERE SET_PROCESS_ID = MSII.SET_PROCESS_ID
7279: AND SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
7280: AND SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
7281: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID

Line 8178: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

8174: END IF; --IF l_security_predicate IS NULL THEN
8175: END IF; --IF NVL(l_import_xref_only, 'N') = 'Y' THEN
8176:
8177: -- resolving transaction type for revisions
8178: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
8179: SET TRANSACTION_TYPE = (
8180: SELECT
8181: (CASE
8182: WHEN MSII.CONFIRM_STATUS = 'CN'

Line 8307: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

8303: CASE
8304: WHEN
8305: (NVL(MSII.REVISION_IMPORT_POLICY, l_import_policy) = 'N' AND
8306: 1 <> (SELECT COUNT(*)
8307: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
8308: WHERE MIRI.SET_PROCESS_ID = MSII.SET_PROCESS_ID
8309: AND MIRI.PROCESS_FLAG = 0
8310: AND MIRI.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8311: AND MIRI.SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE

Line 8331: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

8327: SET CONFIRM_STATUS = (
8328: CASE
8329: WHEN ( NVL(MSII.REVISION_IMPORT_POLICY, l_import_policy) = 'N' AND
8330: 1 <> (SELECT COUNT(*)
8331: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
8332: WHERE MIRI.SET_PROCESS_ID = MSII.SET_PROCESS_ID
8333: AND MIRI.PROCESS_FLAG = 0
8334: AND MIRI.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8335: AND MIRI.SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE

Line 8571: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

8567:
8568: Debug_Conc_Log('Resolve_Child_Entities - After resolving child items' );
8569:
8570: -- updating item_number, item_id from MSII table
8571: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
8572: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER) =
8573: (SELECT
8574: 1,
8575: (CASE

Line 8707: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

8703: WHERE INVENTORY_ITEM_ID = ATTRS.INVENTORY_ITEM_ID
8704: AND ORGANIZATION_ID = ATTRS.ORGANIZATION_ID)
8705: WHEN '2'
8706: THEN (SELECT REVISION
8707: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
8708: WHERE MIRI.SET_PROCESS_ID = ATTRS.DATA_SET_ID
8709: AND MIRI.SOURCE_SYSTEM_ID = ATTRS.SOURCE_SYSTEM_ID
8710: AND MIRI.SOURCE_SYSTEM_REFERENCE = ATTRS.SOURCE_SYSTEM_REFERENCE
8711: AND MIRI.ORGANIZATION_ID = ATTRS.ORGANIZATION_ID

Line 8744: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

8740: AND EXT.APPLICATION_ID = 431
8741: AND A.DATA_LEVEL = 'ITEM_REVISION_LEVEL');
8742:
8743: Debug_Conc_Log('Resolve_Child_Entities - After resolving user attrs intf table for revision' );
8744: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
8745: SET (REVISION, TRANSACTION_TYPE) =
8746: (SELECT
8747: (CASE
8748: WHEN (EXISTS (SELECT NULL

Line 8963: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

8959: Debug_Conc_Log('Resolve_Child_Entities - After updating items intf table for child items that has XXref' );
8960:
8961: -- updating the item revisions
8962: l_sql := q'#
8963: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
8964: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
8965: (SELECT
8966: 1,
8967: NVL(MIRI.TRANSACTION_TYPE, 'SYNC'),

Line 9006: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

9002: -- updating the item revisions where revision is null and revision_import_policy is Update Latest
9003: -- Bug: 5476972
9004: IF l_import_policy = 'L' THEN
9005: l_sql := q'#
9006: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
9007: SET (REVISION, TRANSACTION_TYPE) =
9008: (SELECT MAX(REVISION) KEEP (DENSE_RANK FIRST ORDER BY EFFECTIVITY_DATE DESC), 'UPDATE'
9009: FROM MTL_ITEM_REVISIONS_B
9010: WHERE INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID

Line 9529: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

9525: );
9526: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9527:
9528: -- updating item revisions
9529: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
9530: SET PROCESS_FLAG = 1
9531: WHERE ( INVENTORY_ITEM_ID = l_item_id
9532: OR ( ITEM_NUMBER = l_item_number
9533: AND INVENTORY_ITEM_ID IS NULL

Line 9644: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

9640: );
9641: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9642:
9643: -- updating item revisions
9644: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
9645: SET PROCESS_FLAG = 1
9646: WHERE ITEM_NUMBER = l_item_number
9647: AND PROCESS_FLAG = 3
9648: AND SET_PROCESS_ID = p_batch_id

Line 9903: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

9899: );
9900: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9901:
9902: -- updating item revisions
9903: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
9904: SET PROCESS_FLAG = 1
9905: WHERE SOURCE_SYSTEM_ID = l_ss_id
9906: AND SOURCE_SYSTEM_REFERENCE = l_ssr
9907: AND PROCESS_FLAG = 3

Line 10255: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE

10251: END GET_LATEST_EIUAI_REV_PDH;
10252:
10253: FUNCTION GET_LATEST_MIRI_REV_SS
10254: (
10255: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10256: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10257: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10258: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10256: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE

10252:
10253: FUNCTION GET_LATEST_MIRI_REV_SS
10254: (
10255: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10256: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10257: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10258: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10260: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

Line 10257: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE

10253: FUNCTION GET_LATEST_MIRI_REV_SS
10254: (
10255: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10256: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10257: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10258: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10260: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10261: )

Line 10258: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE

10254: (
10255: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10256: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10257: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10258: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10260: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10261: )
10262: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS

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

10256: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10257: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10258: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10260: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10261: )
10262: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10263: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10264: BEGIN

Line 10262: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS

10258: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10260: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10261: )
10262: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10263: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10264: BEGIN
10265: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10266: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )

Line 10263: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;

10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10260: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10261: )
10262: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10263: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10264: BEGIN
10265: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10266: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10267: INTO l_revision

Line 10269: MTL_ITEM_REVISIONS_INTERFACE MIRI

10265: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10266: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10267: INTO l_revision
10268: FROM
10269: MTL_ITEM_REVISIONS_INTERFACE MIRI
10270: WHERE MIRI.SET_PROCESS_id = p_batch_id
10271: AND MIRI.SOURCE_SYSTEM_ID = p_source_system_id
10272: AND MIRI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
10273: AND MIRI.ORGANIZATION_ID = p_organization_id

Line 10279: MTL_ITEM_REVISIONS_INTERFACE MIRI

10275: ELSE
10276: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10277: INTO l_revision
10278: FROM
10279: MTL_ITEM_REVISIONS_INTERFACE MIRI
10280: WHERE
10281: MIRI.SET_PROCESS_id = p_batch_id
10282: AND MIRI.SOURCE_SYSTEM_ID = p_source_system_id
10283: AND MIRI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference

Line 10296: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE

10292: END GET_LATEST_MIRI_REV_SS;
10293:
10294: FUNCTION GET_LATEST_MIRI_REV_PDH
10295: (
10296: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10297: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10298: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10299: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10297: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE

10293:
10294: FUNCTION GET_LATEST_MIRI_REV_PDH
10295: (
10296: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10297: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10298: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10299: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10301: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL

Line 10298: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE

10294: FUNCTION GET_LATEST_MIRI_REV_PDH
10295: (
10296: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10297: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10298: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10299: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10301: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10302: )

Line 10299: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE

10295: (
10296: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10297: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10298: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10299: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10301: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10302: )
10303: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS

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

10297: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10298: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10299: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10301: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10302: )
10303: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10304: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10305: BEGIN

Line 10303: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS

10299: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10301: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10302: )
10303: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10304: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10305: BEGIN
10306: IF p_inventory_item_id IS NULL THEN
10307: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN

Line 10304: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;

10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10301: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10302: )
10303: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10304: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10305: BEGIN
10306: IF p_inventory_item_id IS NULL THEN
10307: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10308: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST

Line 10311: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

10307: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10308: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10309: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10310: INTO l_revision
10311: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
10312: WHERE MIRI.SET_PROCESS_id = p_batch_id
10313: AND MIRI.ITEM_NUMBER = p_item_number
10314: AND MIRI.ORGANIZATION_ID = p_organization_id
10315: AND MIRI.PROCESS_FLAG = 1;

Line 10320: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

10316: ELSE
10317: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10318: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10319: INTO l_revision
10320: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
10321: WHERE MIRI.SET_PROCESS_id = p_batch_id
10322: AND MIRI.ITEM_NUMBER = p_item_number
10323: AND MIRI.ORGANIZATION_ID = p_organization_id
10324: AND MIRI.REQUEST_ID = p_request_id

Line 10332: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

10328: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10329: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10330: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10331: INTO l_revision
10332: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
10333: WHERE MIRI.SET_PROCESS_id = p_batch_id
10334: AND ( ( MIRI.INVENTORY_ITEM_ID IS NULL AND MIRI.ITEM_NUMBER = p_item_number )
10335: OR MIRI.INVENTORY_ITEM_ID = p_inventory_item_id
10336: )

Line 10343: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

10339: ELSE
10340: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10341: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10342: INTO l_revision
10343: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
10344: WHERE MIRI.SET_PROCESS_id = p_batch_id
10345: AND ( ( MIRI.INVENTORY_ITEM_ID IS NULL AND MIRI.ITEM_NUMBER = p_item_number )
10346: OR MIRI.INVENTORY_ITEM_ID = p_inventory_item_id
10347: )

Line 12450: FROM MTL_ITEM_REVISIONS_INTERFACE miri

12446: THEN 1
12447: ELSE NULL
12448: END
12449: ) UPDATE_CNT
12450: FROM MTL_ITEM_REVISIONS_INTERFACE miri
12451: WHERE SET_PROCESS_ID = p_set_process_id
12452: AND EXISTS
12453: (
12454: SELECT NULL