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_ITEM_BULKLOAD_PKG dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 3286: -- API name : Populate MTL_ITEM_REVISIONS_INTERFACE table

3282: x_retcode OUT NOCOPY VARCHAR2
3283: ) IS
3284:
3285: -- Start OF comments
3286: -- API name : Populate MTL_ITEM_REVISIONS_INTERFACE table
3287: -- TYPE : Private
3288: -- Pre-reqs : None
3289: -- FUNCTION : Populate and Load Item Revisions interfance lines.
3290: -- Loads Item Revision Attr Values

Line 3696: l_dyn_sql := 'INSERT INTO MTL_ITEM_REVISIONS_INTERFACE ';

3692:
3693: -----------------------------------------------------------------
3694: -- Insert rows from EBI into MSII
3695: -----------------------------------------------------------------
3696: l_dyn_sql := 'INSERT INTO MTL_ITEM_REVISIONS_INTERFACE ';
3697: l_dyn_sql := l_dyn_sql || '( ';
3698: l_dyn_sql := l_dyn_sql || ' SET_PROCESS_ID , ';
3699: l_dyn_sql := l_dyn_sql || ' TRANSACTION_ID , ';
3700: l_dyn_sql := l_dyn_sql || ' REQUEST_ID , ';

Line 3772: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';

3768: -- Transfer the Revision Reason information from EBI to MIRI
3769: -- by doing Value-to-ID Conversion.
3770: ----------------------------------------------------------------------------------
3771: l_dyn_sql := '';
3772: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3773: l_dyn_sql := l_dyn_sql || ' SET MIRI.'||G_REV_REASON_DB_COL||' = ';
3774: l_dyn_sql := l_dyn_sql || '( ';
3775: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
3776: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

Line 3830: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';

3826: ----------------------------------------------------------------------------------
3827: ELSE
3828:
3829: l_dyn_sql := '';
3830: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3831: l_dyn_sql := l_dyn_sql || ' SET MIRI.'||l_prod_col_name_tbl(i) ||' = ';
3832: l_dyn_sql := l_dyn_sql || '( ';
3833: l_dyn_sql := l_dyn_sql || ' SELECT EBI.'||l_intf_col_name_tbl(i);
3834: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';

Line 3881: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';

3877: -- by doing Value-to-ID Conversion.
3878: ----------------------------------------------------------------------------------
3879: l_dyn_sql := '';
3880: l_dyn_sql := l_dyn_sql || ' ';
3881: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3882: l_dyn_sql := l_dyn_sql || ' SET MIRI.LIFECYCLE_ID = ';
3883: l_dyn_sql := l_dyn_sql || '( ';
3884: l_dyn_sql := l_dyn_sql || ' SELECT LC.PROJ_ELEMENT_ID ';
3885: l_dyn_sql := l_dyn_sql || ' FROM PA_EGO_LIFECYCLES_PHASES_V LC, EGO_BULKLOAD_INTF EBI ';

Line 3913: -- MTL_ITEM_REVISIONS_INTERFACE.

3909: -- Fix for Bug:3624686
3910: -- As a part of 11.5.10, Setting the Lifecycle for Revision is not available.
3911: -- But setting Lifecycle Phase is still possible.
3912: -- Hence pick up the Lifecycle from Item (MTL_SYSTEM_ITEMS_B) and set in
3913: -- MTL_ITEM_REVISIONS_INTERFACE.
3914: ----------------------------------------------------------------------------------
3915:
3916: ----------------------------------------------------------------------------------
3917: -- First Transfer the Lifecycle ID information from MSI to MSII

Line 3921: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';

3917: -- First Transfer the Lifecycle ID information from MSI to MSII
3918: -- as the Revision inherits Lifecycle ID from Item.
3919: ----------------------------------------------------------------------------------
3920: l_dyn_sql := '';
3921: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3922: l_dyn_sql := l_dyn_sql || ' SET MIRI.LIFECYCLE_ID = ';
3923: l_dyn_sql := l_dyn_sql || '( ';
3924: l_dyn_sql := l_dyn_sql || ' SELECT MSI.LIFECYCLE_ID ';
3925: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI, EGO_BULKLOAD_INTF EBI ';

Line 3955: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';

3951: -- Next Transfer the Lifecycle Phase information from EBI to MSII
3952: -- by doing Value-to-ID Conversion, and by joining Lifecycle ID information.
3953: ----------------------------------------------------------------------------------
3954: l_dyn_sql := '';
3955: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3956: l_dyn_sql := l_dyn_sql || ' SET MIRI.CURRENT_PHASE_ID = ';
3957: l_dyn_sql := l_dyn_sql || '( ';
3958: l_dyn_sql := l_dyn_sql || ' SELECT LCP.PROJ_ELEMENT_ID ';
3959: l_dyn_sql := l_dyn_sql || ' FROM PA_EGO_PHASES_V LCP, EGO_BULKLOAD_INTF EBI ';

Line 3991: load_itm_or_rev_usrattr_intf() that updates UDAs, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE

3987: -- Bug: 5476972 "Rows not to be deleted if Revision is null"
3988: -- bug: 5557250 delete only if all the fields are populated as NULL
3989: --
3990: /* Bug 7578350. Moving this DELETE statement to the function process_item_interface_lines(), after the function call
3991: load_itm_or_rev_usrattr_intf() that updates UDAs, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE
3992: only if there are no Revision Level Attributes provided.
3993:
3994: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI
3995: WHERE revision IS NULL

Line 3994: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI

3990: /* Bug 7578350. Moving this DELETE statement to the function process_item_interface_lines(), after the function call
3991: load_itm_or_rev_usrattr_intf() that updates UDAs, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE
3992: only if there are no Revision Level Attributes provided.
3993:
3994: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI
3995: WHERE revision IS NULL
3996: AND revision_id IS NULL
3997: AND implementation_date IS NULL
3998: AND effectivity_date IS NULL

Line 4013: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

4009:
4010: --
4011: -- convert all date fields values from Excel Null to INTF Null
4012: --
4013: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
4014: SET ecn_initiation_date = DECODE(ecn_initiation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,ecn_initiation_date),
4015: implementation_date = DECODE(implementation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,implementation_date),
4016: effectivity_date = DECODE(effectivity_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,effectivity_date)
4017: WHERE MIRI.TRANSACTION_ID IN

Line 4066: DELETE MTL_ITEM_REVISIONS_INTERFACE

4062: -- Only in case of Import, and while importing Multi-Row attr group
4063: -- values : Item, Org, Revision are NOT NULL, and rest of the base
4064: -- attributes are NULL. Hence can delete these rows off from MIRI.
4065: -----------------------------------------------------------------------
4066: DELETE MTL_ITEM_REVISIONS_INTERFACE
4067: WHERE
4068: (
4069: (
4070: ITEM_NUMBER IS NOT NULL OR

Line 4189: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4185: UPDATE EGO_BULKLOAD_INTF EBI
4186: SET EBI.PROCESS_STATUS =
4187: (
4188: SELECT MIRI.PROCESS_FLAG
4189: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4190: WHERE MIRI.TRANSACTION_ID = EBI.TRANSACTION_ID
4191: )
4192: WHERE EXISTS
4193: (

Line 4195: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4191: )
4192: WHERE EXISTS
4193: (
4194: SELECT 'X'
4195: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4196: WHERE MIRI.TRANSACTION_ID = EBI.TRANSACTION_ID
4197: )
4198: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
4199:

Line 4213: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4209: SET EBI.PROCESS_STATUS = G_INTF_STATUS_ERROR
4210: WHERE EXISTS
4211: (
4212: SELECT 'X'
4213: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4214: WHERE MIRI.TRANSACTION_ID = EBI.TRANSACTION_ID
4215: AND MIRI.PROCESS_FLAG = G_INTF_STATUS_SUCCESS
4216: AND MIRI.REVISION_ID IS NULL
4217: )

Line 4262: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4258: UPDATE EGO_BULKLOAD_INTF EBI
4259: SET EBI.INSTANCE_PK3_VALUE =
4260: (
4261: SELECT MIRI.REVISION_ID
4262: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4263: WHERE MIRI.TRANSACTION_ID = EBI.TRANSACTION_ID
4264: )
4265: WHERE EXISTS
4266: (

Line 4268: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4264: )
4265: WHERE EXISTS
4266: (
4267: SELECT 'X'
4268: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4269: WHERE MIRI.TRANSACTION_ID = EBI.transaction_id
4270: )
4271: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id
4272: AND EBI.PROCESS_STATUS = G_INTF_STATUS_SUCCESS;

Line 6370: by addubg NOT EXITS condition in WHERE caluse, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE

6366: Developer_Debug('UsrAttr_Populate_Process: done. l_retcode = ' || l_retcode);
6367: Developer_Debug('UsrAttr_Populate_Process: l_errbuff = ' || l_errbuff);
6368:
6369: /* Bug 7578350. Moved this DELETE statement from load_item_revs_interface() function,
6370: by addubg NOT EXITS condition in WHERE caluse, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE
6371: only if there are no Revision Level Attributes provided. */
6372:
6373: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI
6374: WHERE revision IS NULL

Line 6373: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI

6369: /* Bug 7578350. Moved this DELETE statement from load_item_revs_interface() function,
6370: by addubg NOT EXITS condition in WHERE caluse, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE
6371: only if there are no Revision Level Attributes provided. */
6372:
6373: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI
6374: WHERE revision IS NULL
6375: AND revision_id IS NULL
6376: AND implementation_date IS NULL
6377: AND effectivity_date IS NULL

Line 7089: UPDATE mtl_item_revisions_interface

7085: source_system_reference = l_ss_ref_table(item_num_row_index));
7086:
7087: -- for item revisions interface table
7088: FORALL rev_row_index IN 1..l_item_rows_processed
7089: UPDATE mtl_item_revisions_interface
7090: SET item_number = l_item_num_table(rev_row_index)
7091: WHERE set_process_id = l_xset_id
7092: AND source_system_id = l_ss_id_table(rev_row_index)
7093: AND process_flag = p_rec_status