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.HZ_PARTY_STAGE dependencies on FND_LOOKUP_VALUES_VL

Line 5571: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

5567: f.PROCEDURE_NAME,
5568: f.STAGED_ATTRIBUTE_COLUMN,
5569: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
5570: nvl(TAG,'C') column_data_type --Bug No: 4279469
5571: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
5572: WHERE ENTITY_NAME = 'PARTY'
5573: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5574: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5575: AND lkp.LOOKUP_TYPE = 'PARTY_LOGICAL_ATTRIBUTE_LIST' --Bug No: 4279469

Line 6976: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

6972: f.PROCEDURE_NAME,
6973: f.STAGED_ATTRIBUTE_COLUMN,
6974: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
6975: nvl(lkp.tag,'C') column_data_type
6976: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
6977: WHERE ENTITY_NAME = 'PARTY_SITES'
6978: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6979: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6980: AND lkp.lookup_type = 'PARTY_SITE_LOGICAL_ATTRIB_LIST'

Line 8280: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

8276: f.PROCEDURE_NAME,
8277: f.STAGED_ATTRIBUTE_COLUMN,
8278: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
8279: nvl(lkp.tag,'C') column_data_type
8280: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
8281: WHERE ENTITY_NAME = 'CONTACTS'
8282: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8283: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8284: AND lkp.LOOKUP_TYPE='CONTACT_LOGICAL_ATTRIB_LIST'

Line 9559: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469

9555: f.PROCEDURE_NAME,
9556: f.STAGED_ATTRIBUTE_COLUMN,
9557: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
9558: nvl(lkp.tag,'C') column_data_type
9559: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
9560: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9561: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9562: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9563: -- REPURI. Added the 2 lines here for bug 4957189, which were missed in bug 4279469 fix.