DBA Data[Home] [Help]

APPS.MST_SNAPSHOT_TASK_UTIL dependencies on HZ_RELATIONSHIPS

Line 19: from hz_relationships hzpr

15: and rownum = 1;
16:
17: cursor getSupplierId( lownerId in number) is
18: select hzpr.OBJECT_ID
19: from hz_relationships hzpr
20: where hzpr.SUBJECT_ID = lownerId
21: and hzpr.RELATIONSHIP_CODE = 'POS_VENDOR_PARTY'
22: and hzpr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
23: AND hzpr.OBJECT_TABLE_NAME = 'HZ_PARTIES'