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_SYSTEM_ITEMS_INTERFACE_S

Line 1215: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

1211: --------------------------------------------------------------------
1212: UPDATE ego_bulkload_intf
1213: --The Transaction ID sequence that is used in INVPOPIF package to
1214: --auto-populate Transaction ID in MSII.
1215: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
1216: WHERE resultfmt_usage_id = p_resultfmt_usage_id;
1217:
1218: Write_Debug('Retrieving the Display and INTF cols');
1219: i := 0;

Line 3404: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

3400: -- this was happening because the error was logged with a previous transaction id and
3401: -- here a new transaction id was updated to Bulkload interface table.
3402: IF p_data_level <> G_ITEM_DATA_LEVEL THEN
3403: UPDATE ego_bulkload_intf
3404: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
3405: WHERE resultfmt_usage_id = p_resultfmt_usage_id;
3406: END IF;
3407:
3408: Write_Debug('Retrieving the Display and INTF cols');

Line 7515: l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL , ';

7511: END IF;
7512: l_dyn_sql := l_dyn_sql || 'EBI.'||l_org_code_col ||' , ';
7513: l_dyn_sql := l_dyn_sql || '''SYNC'' , ';
7514: l_dyn_sql := l_dyn_sql || G_PROCESS_STATUS||' , ';
7515: l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL , ';
7516: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATED_BY , ';
7517: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATION_DATE , ';
7518: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATED_BY , ';
7519: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATE_DATE , ';

Line 7610: l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL , ';

7606: l_dyn_sql := l_dyn_sql || ' SOURCE_SYSTEM_REFERENCE , ';
7607: l_dyn_sql := l_dyn_sql || ' ASSOCIATION_ID ';
7608: l_dyn_sql := l_dyn_sql || ' ) ';
7609: l_dyn_sql := l_dyn_sql || 'SELECT ';
7610: l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL , ';
7611: l_dyn_sql := l_dyn_sql || ' INTERSECTIONS.* ';
7612: l_dyn_sql := l_dyn_sql || ' FROM ( ';
7613:
7614: l_dyn_sql := l_dyn_sql || 'SELECT ';

Line 7649: --l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL, ';

7645: l_dyn_sql := l_dyn_sql || 'EBI.'||l_supplier_site_name_col ||' , ';
7646: l_dyn_sql := l_dyn_sql || 'EBI.'||l_org_code_col ||' , ';
7647: l_dyn_sql := l_dyn_sql || '''SYNC'' , ';
7648: l_dyn_sql := l_dyn_sql || G_PROCESS_STATUS||' , ';
7649: --l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL, ';
7650: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATED_BY , ';
7651: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATION_DATE , ';
7652: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATED_BY , ';
7653: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATE_DATE , ';

Line 7711: --l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL, ';

7707:
7708: l_dyn_sql := l_dyn_sql || 'EBI.'||l_org_code_col ||' , ';
7709: l_dyn_sql := l_dyn_sql || '''SYNC'' , ';
7710: l_dyn_sql := l_dyn_sql || G_PROCESS_STATUS||' , ';
7711: --l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL, ';
7712: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATED_BY , ';
7713: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATION_DATE , ';
7714: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATED_BY , ';
7715: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATE_DATE , ';