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_STYLE_SKU_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 159: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

155: BEGIN
156: IF (p_copy_inventory_item_Id IS NOT NULL) THEN
157: l_copy_from_organization_id := p_organization_id;
158: END IF;
159: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
160: ( SET_PROCESS_ID,
161: PROCESS_FLAG,
162: TRANSACTION_TYPE,
163: TEMPLATE_ID,

Line 357: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

353: l_org_assignment := 'N';
354: l_inventory_item_id := NULL;
355: END;
356:
357: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
358: ( SET_PROCESS_ID ,
359: PROCESS_FLAG ,
360: TRANSACTION_TYPE ,
361: TEMPLATE_ID ,

Line 519: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;

515: )
516: )
517: ORDER BY ATTR_EXT.ATTR_ID;
518:
519: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;

Line 520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;

516: )
517: ORDER BY ATTR_EXT.ATTR_ID;
518:
519: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;

Line 521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;

517: ORDER BY ATTR_EXT.ATTR_ID;
518:
519: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
525: l_concat_value VARCHAR2(32000);

Line 522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;

518:
519: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
525: l_concat_value VARCHAR2(32000);
526: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;

519: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
525: l_concat_value VARCHAR2(32000);
526: l_user_id NUMBER := FND_GLOBAL.USER_ID;
527: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

Line 524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;

520: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
521: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
522: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
523: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
524: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
525: l_concat_value VARCHAR2(32000);
526: l_user_id NUMBER := FND_GLOBAL.USER_ID;
527: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
528: l_delimeter EGO_DEFAULT_OPTIONS.OPTION_VALUE%TYPE;

Line 538: FROM MTL_SYSTEM_ITEMS_INTERFACE

534:
535: l_delimeter := NVL(EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_SKU_CONCAT_VA_DELIM'), '.');
536: SELECT SET_PROCESS_ID, INVENTORY_ITEM_ID, ITEM_NUMBER, ORGANIZATION_ID, ITEM_CATALOG_GROUP_ID, STYLE_ITEM_ID
537: INTO l_batch_id, l_sku_item_id, l_item_number, l_org_id, l_category_id, l_style_item_id
538: FROM MTL_SYSTEM_ITEMS_INTERFACE
539: WHERE ROWID = p_intf_row_id;
540:
541: Debug_Conc_Log('Batch_id, item_id, item_number, org_id, icc_id, style_item_id='||
542: l_batch_id||', '||l_sku_item_id||', '||l_item_number||', '||l_org_id||', '||

Line 828: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

824: ,x_return_status OUT NOCOPY VARCHAR2
825: ,x_msg_data OUT NOCOPY VARCHAR2)
826: IS
827: BEGIN
828: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
829: ( SET_PROCESS_ID,
830: PROCESS_FLAG,
831: TRANSACTION_TYPE,
832: ITEM_CATALOG_GROUP_ID,

Line 852: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,

848: p_organization_id,
849: p_item_number,
850: p_style_item_flag,
851: p_style_item_id,
852: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
853: EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID,
854: 'FK'
855: );
856: