DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PARTY_SITE_BO_PVT dependencies on HZ_ORIG_SYS_REF_OBJ_TBL

Line 176: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),

172: FROM HZ_ORIG_SYS_REFERENCES OSR
173: WHERE
174: OSR.OWNER_TABLE_ID = PS.PARTY_SITE_ID
175: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
176: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
177: HZ_EXT_ATTRIBUTE_OBJ_TBL(),
178: HZ_LOCATION_OBJ(
179: P_ACTION_TYPE,
180: NULL, -- COMMON_OBJ_ID

Line 250: HZ_ORIG_SYS_REF_OBJ_TBL(),

246: LOC.ACTUAL_CONTENT_SOURCE,
247: LOC.DELIVERY_POINT_CODE,
248: LOC.GEOMETRY_STATUS_CODE,
249: LOC.GEOMETRY,
250: HZ_ORIG_SYS_REF_OBJ_TBL(),
251: HZ_EXT_ATTRIBUTE_OBJ_TBL()),
252: CAST(MULTISET (
253: SELECT
254: HZ_PARTY_SITE_USE_OBJ(