DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE dependencies on FND_LOOKUP_VALUES_VL

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

5413: f.PROCEDURE_NAME,
5414: f.STAGED_ATTRIBUTE_COLUMN,
5415: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
5416: nvl(TAG,'C') column_data_type --Bug No: 4279469
5417: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
5418: WHERE ENTITY_NAME = 'PARTY'
5419: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
5420: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5421: AND lkp.LOOKUP_TYPE = 'PARTY_LOGICAL_ATTRIBUTE_LIST' --Bug No: 4279469

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

6818: f.PROCEDURE_NAME,
6819: f.STAGED_ATTRIBUTE_COLUMN,
6820: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
6821: nvl(lkp.tag,'C') column_data_type
6822: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
6823: WHERE ENTITY_NAME = 'PARTY_SITES'
6824: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
6825: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
6826: AND lkp.lookup_type = 'PARTY_SITE_LOGICAL_ATTRIB_LIST'

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

8122: f.PROCEDURE_NAME,
8123: f.STAGED_ATTRIBUTE_COLUMN,
8124: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
8125: nvl(lkp.tag,'C') column_data_type
8126: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
8127: WHERE ENTITY_NAME = 'CONTACTS'
8128: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
8129: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
8130: AND lkp.LOOKUP_TYPE='CONTACT_LOGICAL_ATTRIB_LIST'

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

9401: f.PROCEDURE_NAME,
9402: f.STAGED_ATTRIBUTE_COLUMN,
9403: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
9404: nvl(lkp.tag,'C') column_data_type
9405: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4279469
9406: WHERE ENTITY_NAME = 'CONTACT_POINTS'
9407: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
9408: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9409: -- REPURI. Added the 2 lines here for bug 4957189, which were missed in bug 4279469 fix.