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.

[Home] [Help]

APPS.EGO_GTIN_ATTRS_PVT dependencies on EGO_ITM_USR_ATTR_INTRFC

Line 222: FROM EGO_ITM_USR_ATTR_INTRFC

218: ,MAX(DECODE(ATTR_GROUP_INT_NAME, 'Uccnet_Hardlines', DECODE(ATTR_INT_NAME, 'URL_FOR_WARRANTY', NVL(ATTR_VALUE_STR, G_MISS_CHAR), null), null)) AS URL_FOR_WARRANTY
219: ,MAX(DECODE(ATTR_GROUP_INT_NAME, 'Uccnet_Hardlines', DECODE(ATTR_INT_NAME, 'IS_OUT_OF_BOX_PROVIDED', NVL(ATTR_VALUE_STR, G_MISS_CHAR), null), null)) AS IS_OUT_OF_BOX_PROVIDED
220: ,MAX(DECODE(ATTR_GROUP_INT_NAME, 'Uccnet_Hardlines', DECODE(ATTR_INT_NAME, 'RETURN_GOODS_POLICY', NVL(ATTR_VALUE_STR, G_MISS_CHAR), null), null)) AS RETURN_GOODS_POLICY
221: ,MAX(DECODE(ATTR_GROUP_INT_NAME, 'Uccnet_Size_Description', DECODE(ATTR_INT_NAME, 'Size_Description', NVL(ATTR_VALUE_STR, G_MISS_CHAR), null), null)) AS DESCRIPTIVE_SIZE
222: FROM EGO_ITM_USR_ATTR_INTRFC
223: WHERE ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
224: AND DATA_SET_ID = p_data_set_id
225: AND PROCESS_STATUS = p_target_proc_status
226: AND INVENTORY_ITEM_ID = c_inventory_item_id

Line 253: FROM EGO_ITM_USR_ATTR_INTRFC

249: ,MAX(DECODE(ATTR_GROUP_INT_NAME, 'Manufacturing_Info', DECODE(ATTR_INT_NAME, 'Name_Of_Manufacturer', NVL(ATTR_VALUE_NUM, G_MISS_NUM), null), null)) AS MANUFACTURER_ID
250: ,MAX(DECODE(ATTR_GROUP_INT_NAME, 'Size_Description', DECODE(ATTR_INT_NAME, 'SIZE_CODE_LIST_AGENCY', NVL(ATTR_VALUE_STR, G_MISS_CHAR), null), null)) AS SIZE_CODE_LIST_AGENCY
251: ,MAX(DECODE(ATTR_GROUP_INT_NAME, 'Size_Description', DECODE(ATTR_INT_NAME, 'SIZE_CODE_VALUE', NVL(ATTR_VALUE_STR, G_MISS_CHAR), null), null)) AS SIZE_CODE_VALUE
252: ,MAX(DECODE(ATTR_GROUP_INT_NAME, 'TRADE_ITEM_HARMN_SYS_IDENT', DECODE(ATTR_INT_NAME, 'HARMONIZED_TARIFF_SYS_ID_CODE', NVL(ATTR_VALUE_NUM, G_MISS_NUM), null), null)) AS HARMONIZED_TARIFF_SYS_ID_CODE
253: FROM EGO_ITM_USR_ATTR_INTRFC
254: WHERE ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_MULTI_ATTRS'
255: AND DATA_SET_ID = p_data_set_id
256: AND PROCESS_STATUS = p_target_proc_status
257: AND INVENTORY_ITEM_ID = c_inventory_item_id

Line 1617: FROM EGO_ITM_USR_ATTR_INTRFC

1613: ,MAX(CREATION_DATE) AS CREATION_DATE
1614: ,MAX(LAST_UPDATED_BY) AS LAST_UPDATED_BY
1615: ,MAX(LAST_UPDATE_DATE) AS LAST_UPDATE_DATE
1616: ,MAX(LAST_UPDATE_LOGIN) AS LAST_UPDATE_LOGIN
1617: FROM EGO_ITM_USR_ATTR_INTRFC
1618: WHERE (( ATTR_GROUP_TYPE IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS') )
1619: OR
1620: ( ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND ATTR_GROUP_INT_NAME LIKE 'EGOINT#_GDSN%' ESCAPE '#' )
1621: )

Line 1652: UPDATE EGO_ITM_USR_ATTR_INTRFC

1648: x_return_status := l_return_status;
1649:
1650: IF l_return_status <> 'S' THEN
1651: Debug_Msg('Done with errors - Calling Get_Gdsn_Intf_Rows for Item, Org='||i.INVENTORY_ITEM_ID||','||i.ORGANIZATION_ID);
1652: UPDATE EGO_ITM_USR_ATTR_INTRFC
1653: SET PROCESS_STATUS = 3
1654: WHERE DATA_SET_ID = p_data_set_id
1655: AND (( ATTR_GROUP_TYPE IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS') )
1656: OR

Line 1675: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

1671: ,p_application_id => 'EGO'
1672: ,p_message_type => FND_API.G_RET_STS_ERROR
1673: ,p_row_identifier => i.TRANSACTION_ID
1674: ,p_entity_id => p_entity_id
1675: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
1676: ,p_entity_code => p_entity_code
1677: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
1678: );
1679: END LOOP;

Line 1690: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

1686: ,p_application_id => 'EGO'
1687: ,p_message_type => FND_API.G_RET_STS_ERROR
1688: ,p_row_identifier => i.TRANSACTION_ID
1689: ,p_entity_id => p_entity_id
1690: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
1691: ,p_entity_code => p_entity_code
1692: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
1693: );
1694: END IF; -- IF l_msg_count

Line 1719: UPDATE EGO_ITM_USR_ATTR_INTRFC

1715: x_return_status := l_return_status;
1716: Debug_Msg('Finished Validation l_return_status, l_msg_count='||l_return_status||','||l_msg_count);
1717:
1718: IF l_return_status <> 'S' THEN
1719: UPDATE EGO_ITM_USR_ATTR_INTRFC
1720: SET PROCESS_STATUS = 3
1721: WHERE DATA_SET_ID = p_data_set_id
1722: AND (( ATTR_GROUP_TYPE IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS') )
1723: OR

Line 1743: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

1739: ,p_application_id => 'EGO'
1740: ,p_message_type => FND_API.G_RET_STS_ERROR
1741: ,p_row_identifier => i.TRANSACTION_ID
1742: ,p_entity_id => p_entity_id
1743: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
1744: ,p_entity_code => p_entity_code
1745: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
1746: );
1747: END LOOP;

Line 1758: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

1754: ,p_application_id => 'EGO'
1755: ,p_message_type => FND_API.G_RET_STS_ERROR
1756: ,p_row_identifier => i.TRANSACTION_ID
1757: ,p_entity_id => p_entity_id
1758: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
1759: ,p_entity_code => p_entity_code
1760: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
1761: );
1762: END IF; -- IF l_msg_count

Line 2733: FROM EGO_ITM_USR_ATTR_INTRFC

2729: INVENTORY_ITEM_ID,
2730: ITEM_NUMBER,
2731: MAX(DECODE(ATTR_GROUP_INT_NAME, 'Trade_Item_Description', DECODE(ATTR_INT_NAME, 'Eanucc_Code', ATTR_VALUE_STR, null), null)) AS EANUCC_CODE,
2732: MAX(DECODE(ATTR_GROUP_INT_NAME, 'Trade_Item_Description', DECODE(ATTR_INT_NAME, 'EANUCC_Type', ATTR_VALUE_STR, null), null)) AS EANUCC_TYPE
2733: FROM EGO_ITM_USR_ATTR_INTRFC
2734: WHERE ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
2735: AND DATA_SET_ID = G_DATA_SET_ID
2736: AND PROCESS_STATUS = 2
2737: AND INVENTORY_ITEM_ID <> p_inventory_item_id

Line 3554: FROM EGO_ITM_USR_ATTR_INTRFC

3550: INVENTORY_ITEM_ID
3551: ,ORGANIZATION_ID
3552: ,ITEM_CATALOG_GROUP_ID
3553: ,MAX(TRANSACTION_ID) AS TRANSACTION_ID
3554: FROM EGO_ITM_USR_ATTR_INTRFC
3555: WHERE ATTR_GROUP_TYPE IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
3556: AND DATA_SET_ID = p_data_set_id
3557: AND PROCESS_STATUS = 2
3558: GROUP BY INVENTORY_ITEM_ID, ORGANIZATION_ID, ITEM_CATALOG_GROUP_ID;

Line 3569: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_ATTRS_V eav

3565: ,eiuai.ATTR_INT_NAME
3566: ,eiuai.ATTR_VALUE_STR
3567: ,eiuai.ATTR_VALUE_NUM
3568: ,eiuai.ATTR_VALUE_DATE
3569: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_ATTRS_V eav
3570: WHERE eiuai.ATTR_GROUP_TYPE IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
3571: AND eiuai.ATTR_GROUP_TYPE = eav.ATTR_GROUP_TYPE
3572: AND eiuai.ATTR_GROUP_INT_NAME = eav.ATTR_GROUP_NAME
3573: AND eiuai.ATTR_INT_NAME = eav.ATTR_NAME

Line 3586: FROM EGO_ITM_USR_ATTR_INTRFC

3582: INVENTORY_ITEM_ID
3583: ,ORGANIZATION_ID
3584: ,ATTR_GROUP_INT_NAME
3585: ,MAX(TRANSACTION_ID) AS TRANSACTION_ID
3586: FROM EGO_ITM_USR_ATTR_INTRFC
3587: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
3588: AND ATTR_GROUP_INT_NAME LIKE 'EGOINT#_GDSN%' ESCAPE '#'
3589: AND DATA_SET_ID = p_data_set_id
3590: AND PROCESS_STATUS = 2

Line 3598: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

3594: SELECT
3595: eiuai.INVENTORY_ITEM_ID
3596: ,eiuai.ORGANIZATION_ID
3597: ,eiuai.ATTR_INT_NAME
3598: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
3599: WHERE eiuai.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
3600: AND eiuai.ATTR_GROUP_INT_NAME = c_attr_group_name
3601: AND eiuai.DATA_SET_ID = p_data_set_id
3602: AND eiuai.PROCESS_STATUS = 2

Line 3662: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

3658: ,p_application_id => 'EGO'
3659: ,p_message_type => FND_API.G_RET_STS_ERROR
3660: ,p_row_identifier => i.TRANSACTION_ID
3661: ,p_entity_id => p_entity_id
3662: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
3663: ,p_entity_code => p_entity_code
3664: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
3665: );
3666: END IF; -- end IF l_return_st

Line 3699: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

3695: ,p_application_id => 'EGO'
3696: ,p_message_type => FND_API.G_RET_STS_ERROR
3697: ,p_row_identifier => i.TRANSACTION_ID
3698: ,p_entity_id => p_entity_id
3699: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
3700: ,p_entity_code => p_entity_code
3701: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
3702: );
3703: END IF; -- end IF l_msg_data

Line 3740: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

3736: ,p_application_id => 'EGO'
3737: ,p_message_type => FND_API.G_RET_STS_ERROR
3738: ,p_row_identifier => i.TRANSACTION_ID
3739: ,p_entity_id => p_entity_id
3740: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
3741: ,p_entity_code => p_entity_code
3742: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
3743: );
3744: END IF; -- end IF l_return_st