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 3371: -- API name : Populate MTL_ITEM_REVISIONS_INTERFACE table

3367: x_retcode OUT NOCOPY VARCHAR2
3368: ) IS
3369:
3370: -- Start OF comments
3371: -- API name : Populate MTL_ITEM_REVISIONS_INTERFACE table
3372: -- TYPE : Private
3373: -- Pre-reqs : None
3374: -- FUNCTION : Populate and Load Item Revisions interfance lines.
3375: -- Loads Item Revision Attr Values

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

3777:
3778: -----------------------------------------------------------------
3779: -- Insert rows from EBI into MSII
3780: -----------------------------------------------------------------
3781: l_dyn_sql := 'INSERT INTO MTL_ITEM_REVISIONS_INTERFACE ';
3782: l_dyn_sql := l_dyn_sql || '( ';
3783: l_dyn_sql := l_dyn_sql || ' SET_PROCESS_ID , ';
3784: l_dyn_sql := l_dyn_sql || ' TRANSACTION_ID , ';
3785: l_dyn_sql := l_dyn_sql || ' REQUEST_ID , ';

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

3853: -- Transfer the Revision Reason information from EBI to MIRI
3854: -- by doing Value-to-ID Conversion.
3855: ----------------------------------------------------------------------------------
3856: l_dyn_sql := '';
3857: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3858: l_dyn_sql := l_dyn_sql || ' SET MIRI.'||G_REV_REASON_DB_COL||' = ';
3859: l_dyn_sql := l_dyn_sql || '( ';
3860: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
3861: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

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

3911: ----------------------------------------------------------------------------------
3912: ELSE
3913:
3914: l_dyn_sql := '';
3915: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3916: l_dyn_sql := l_dyn_sql || ' SET MIRI.'||l_prod_col_name_tbl(i) ||' = ';
3917: l_dyn_sql := l_dyn_sql || '( ';
3918: l_dyn_sql := l_dyn_sql || ' SELECT EBI.'||l_intf_col_name_tbl(i);
3919: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';

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

3962: -- by doing Value-to-ID Conversion.
3963: ----------------------------------------------------------------------------------
3964: l_dyn_sql := '';
3965: l_dyn_sql := l_dyn_sql || ' ';
3966: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3967: l_dyn_sql := l_dyn_sql || ' SET MIRI.LIFECYCLE_ID = ';
3968: l_dyn_sql := l_dyn_sql || '( ';
3969: l_dyn_sql := l_dyn_sql || ' SELECT LC.PROJ_ELEMENT_ID ';
3970: l_dyn_sql := l_dyn_sql || ' FROM PA_EGO_LIFECYCLES_PHASES_V LC, EGO_BULKLOAD_INTF EBI ';

Line 3998: -- MTL_ITEM_REVISIONS_INTERFACE.

3994: -- Fix for Bug:3624686
3995: -- As a part of 11.5.10, Setting the Lifecycle for Revision is not available.
3996: -- But setting Lifecycle Phase is still possible.
3997: -- Hence pick up the Lifecycle from Item (MTL_SYSTEM_ITEMS_B) and set in
3998: -- MTL_ITEM_REVISIONS_INTERFACE.
3999: ----------------------------------------------------------------------------------
4000:
4001: ----------------------------------------------------------------------------------
4002: -- First Transfer the Lifecycle ID information from MSI to MSII

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

4002: -- First Transfer the Lifecycle ID information from MSI to MSII
4003: -- as the Revision inherits Lifecycle ID from Item.
4004: ----------------------------------------------------------------------------------
4005: l_dyn_sql := '';
4006: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
4007: l_dyn_sql := l_dyn_sql || ' SET MIRI.LIFECYCLE_ID = ';
4008: l_dyn_sql := l_dyn_sql || '( ';
4009: l_dyn_sql := l_dyn_sql || ' SELECT MSI.LIFECYCLE_ID ';
4010: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_B MSI, EGO_BULKLOAD_INTF EBI ';

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

4036: -- Next Transfer the Lifecycle Phase information from EBI to MSII
4037: -- by doing Value-to-ID Conversion, and by joining Lifecycle ID information.
4038: ----------------------------------------------------------------------------------
4039: l_dyn_sql := '';
4040: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
4041: l_dyn_sql := l_dyn_sql || ' SET MIRI.CURRENT_PHASE_ID = ';
4042: l_dyn_sql := l_dyn_sql || '( ';
4043: l_dyn_sql := l_dyn_sql || ' SELECT LCP.PROJ_ELEMENT_ID ';
4044: l_dyn_sql := l_dyn_sql || ' FROM PA_EGO_PHASES_V LCP, EGO_BULKLOAD_INTF EBI ';

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

4072: -- Bug: 5476972 "Rows not to be deleted if Revision is null"
4073: -- bug: 5557250 delete only if all the fields are populated as NULL
4074: --
4075: /* Bug 7578350. Moving this DELETE statement to the function process_item_interface_lines(), after the function call
4076: load_itm_or_rev_usrattr_intf() that updates UDAs, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE
4077: only if there are no Revision Level Attributes provided.
4078:
4079: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI
4080: WHERE revision IS NULL

Line 4079: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI

4075: /* Bug 7578350. Moving this DELETE statement to the function process_item_interface_lines(), after the function call
4076: load_itm_or_rev_usrattr_intf() that updates UDAs, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE
4077: only if there are no Revision Level Attributes provided.
4078:
4079: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI
4080: WHERE revision IS NULL
4081: AND revision_id IS NULL
4082: AND implementation_date IS NULL
4083: AND effectivity_date IS NULL

Line 4098: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

4094:
4095: --
4096: -- convert all date fields values from Excel Null to INTF Null
4097: --
4098: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
4099: SET ecn_initiation_date = DECODE(ecn_initiation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,ecn_initiation_date),
4100: implementation_date = DECODE(implementation_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,implementation_date),
4101: effectivity_date = DECODE(effectivity_date,G_EXCEL_NULL_DATE,EGO_ITEM_PUB.G_INTF_NULL_DATE,effectivity_date)
4102: WHERE MIRI.TRANSACTION_ID IN

Line 4151: DELETE MTL_ITEM_REVISIONS_INTERFACE

4147: -- Only in case of Import, and while importing Multi-Row attr group
4148: -- values : Item, Org, Revision are NOT NULL, and rest of the base
4149: -- attributes are NULL. Hence can delete these rows off from MIRI.
4150: -----------------------------------------------------------------------
4151: DELETE MTL_ITEM_REVISIONS_INTERFACE
4152: WHERE
4153: (
4154: (
4155: ITEM_NUMBER IS NOT NULL OR

Line 4274: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4270: UPDATE EGO_BULKLOAD_INTF EBI
4271: SET EBI.PROCESS_STATUS =
4272: (
4273: SELECT MIRI.PROCESS_FLAG
4274: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4275: WHERE MIRI.TRANSACTION_ID = EBI.TRANSACTION_ID
4276: )
4277: WHERE EXISTS
4278: (

Line 4280: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4276: )
4277: WHERE EXISTS
4278: (
4279: SELECT 'X'
4280: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4281: WHERE MIRI.TRANSACTION_ID = EBI.TRANSACTION_ID
4282: )
4283: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
4284:

Line 4298: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4294: SET EBI.PROCESS_STATUS = G_INTF_STATUS_ERROR
4295: WHERE EXISTS
4296: (
4297: SELECT 'X'
4298: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4299: WHERE MIRI.TRANSACTION_ID = EBI.TRANSACTION_ID
4300: AND MIRI.PROCESS_FLAG = G_INTF_STATUS_SUCCESS
4301: AND MIRI.REVISION_ID IS NULL
4302: )

Line 4347: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4343: UPDATE EGO_BULKLOAD_INTF EBI
4344: SET EBI.INSTANCE_PK3_VALUE =
4345: (
4346: SELECT MIRI.REVISION_ID
4347: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4348: WHERE MIRI.TRANSACTION_ID = EBI.TRANSACTION_ID
4349: )
4350: WHERE EXISTS
4351: (

Line 4353: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

4349: )
4350: WHERE EXISTS
4351: (
4352: SELECT 'X'
4353: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
4354: WHERE MIRI.TRANSACTION_ID = EBI.transaction_id
4355: )
4356: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id
4357: AND EBI.PROCESS_STATUS = G_INTF_STATUS_SUCCESS;

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

6519: Developer_Debug('UsrAttr_Populate_Process: done. l_retcode = ' || l_retcode);
6520: Developer_Debug('UsrAttr_Populate_Process: l_errbuff = ' || l_errbuff);
6521:
6522: /* Bug 7578350. Moved this DELETE statement from load_item_revs_interface() function,
6523: by addubg NOT EXITS condition in WHERE caluse, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE
6524: only if there are no Revision Level Attributes provided. */
6525:
6526: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI
6527: WHERE revision IS NULL

Line 6526: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI

6522: /* Bug 7578350. Moved this DELETE statement from load_item_revs_interface() function,
6523: by addubg NOT EXITS condition in WHERE caluse, so that we delete the rows from MTL_ITEM_REVISIONS_INTERFACE
6524: only if there are no Revision Level Attributes provided. */
6525:
6526: DELETE MTL_ITEM_REVISIONS_INTERFACE MIRI
6527: WHERE revision IS NULL
6528: AND revision_id IS NULL
6529: AND implementation_date IS NULL
6530: AND effectivity_date IS NULL

Line 7242: UPDATE mtl_item_revisions_interface

7238: source_system_reference = l_ss_ref_table(item_num_row_index));
7239:
7240: -- for item revisions interface table
7241: FORALL rev_row_index IN 1..l_item_rows_processed
7242: UPDATE mtl_item_revisions_interface
7243: SET item_number = l_item_num_table(rev_row_index)
7244: WHERE set_process_id = l_xset_id
7245: AND source_system_id = l_ss_id_table(rev_row_index)
7246: AND process_flag = p_rec_status