DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE_SHADOW dependencies on FND_LOOKUP_VALUES_VL

Line 2564: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701

2560: f.PROCEDURE_NAME,
2561: f.STAGED_ATTRIBUTE_COLUMN,
2562: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
2563: nvl(TAG,'C') column_data_type --Bug No: 4954701
2564: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701
2565: WHERE ENTITY_NAME = 'PARTY'
2566: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
2567: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
2568: AND lkp.LOOKUP_TYPE = 'PARTY_LOGICAL_ATTRIBUTE_LIST' --Bug No: 4954701

Line 3141: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701

3137: f.PROCEDURE_NAME,
3138: f.STAGED_ATTRIBUTE_COLUMN,
3139: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
3140: nvl(lkp.tag,'C') column_data_type
3141: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701
3142: WHERE ENTITY_NAME = 'PARTY_SITES'
3143: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3144: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3145: AND lkp.lookup_type = 'PARTY_SITE_LOGICAL_ATTRIB_LIST'

Line 3551: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701

3547: f.PROCEDURE_NAME,
3548: f.STAGED_ATTRIBUTE_COLUMN,
3549: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
3550: nvl(lkp.tag,'C') column_data_type
3551: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701
3552: WHERE ENTITY_NAME = 'CONTACTS'
3553: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3554: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3555: AND lkp.LOOKUP_TYPE='CONTACT_LOGICAL_ATTRIB_LIST'

Line 3970: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701

3966: f.PROCEDURE_NAME,
3967: f.STAGED_ATTRIBUTE_COLUMN,
3968: to_number(substrb(STAGED_ATTRIBUTE_COLUMN, 3)) COLNUM,
3969: nvl(lkp.tag,'C') column_data_type
3970: FROM HZ_TRANS_ATTRIBUTES_VL a, HZ_TRANS_FUNCTIONS_VL f,FND_LOOKUP_VALUES_VL lkp --Bug No: 4954701
3971: WHERE ENTITY_NAME = 'CONTACT_POINTS'
3972: AND nvl(f.ACTIVE_FLAG,'Y') = 'Y'
3973: AND f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3974: AND lkp.LOOKUP_TYPE = 'CONTACT_PT_LOGICAL_ATTRIB_LIST'