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.

APPS.HZ_PURGE_GEN dependencies on AP_SUPPLIER_CONTACTS

Line 2054: (select 'Y' from AP_SUPPLIER_CONTACTS

2050: xx where xx.OBJECT_ID = temp.party_id
2051: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2052: AND directional_flag = 'F')
2053: and exists
2054: (select 'Y' from AP_SUPPLIER_CONTACTS
2055: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2056: ))
2057: or exists (select 'Y' from HZ_RELATIONSHIPS
2058: xx where xx.PARTY_ID = temp.party_id

Line 2062: (select 'Y' from AP_SUPPLIER_CONTACTS

2058: xx where xx.PARTY_ID = temp.party_id
2059: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2060: AND directional_flag = 'F')
2061: and exists
2062: (select 'Y' from AP_SUPPLIER_CONTACTS
2063: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2064: ))
2065: or exists (select 'Y' from HZ_RELATIONSHIPS
2066: xx where xx.SUBJECT_ID = temp.party_id

Line 2070: (select 'Y' from AP_SUPPLIER_CONTACTS

2066: xx where xx.SUBJECT_ID = temp.party_id
2067: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2068: AND directional_flag = 'F')
2069: and exists
2070: (select 'Y' from AP_SUPPLIER_CONTACTS
2071: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2072: ))
2073:
2074: or exists (select 'Y' from HZ_PARTY_SITES

Line 2082: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

2078: (select 'Y' from HZ_ORG_CONTACTS
2079: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2080: and nvl(STATUS, 'A') in ('A','I')
2081: and exists
2082: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2083: or exists (select 'Y' from HZ_RELATIONSHIPS
2084: xx where xx.OBJECT_ID = temp.party_id
2085: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2086: AND directional_flag = 'F')

Line 2092: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

2088: (select 'Y' from HZ_ORG_CONTACTS
2089: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2090: and nvl(STATUS, 'A') in ('A','I')
2091: and exists
2092: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2093: or exists (select 'Y' from HZ_RELATIONSHIPS
2094: xx where xx.PARTY_ID = temp.party_id
2095: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2096: AND directional_flag = 'F')

Line 2102: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

2098: (select 'Y' from HZ_ORG_CONTACTS
2099: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2100: and nvl(STATUS, 'A') in ('A','I')
2101: and exists
2102: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2103: or exists (select 'Y' from HZ_RELATIONSHIPS
2104: xx where xx.SUBJECT_ID = temp.party_id
2105: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2106: AND directional_flag = 'F')

Line 2112: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

2108: (select 'Y' from HZ_ORG_CONTACTS
2109: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2110: and nvl(STATUS, 'A') in ('A','I')
2111: and exists
2112: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2113:
2114: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.PER_PARTY_ID = temp.party_id
2115: )
2116:

Line 2114: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.PER_PARTY_ID = temp.party_id

2110: and nvl(STATUS, 'A') in ('A','I')
2111: and exists
2112: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2113:
2114: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.PER_PARTY_ID = temp.party_id
2115: )
2116:
2117: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.REL_PARTY_ID = temp.party_id
2118: )

Line 2117: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.REL_PARTY_ID = temp.party_id

2113:
2114: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.PER_PARTY_ID = temp.party_id
2115: )
2116:
2117: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.REL_PARTY_ID = temp.party_id
2118: )
2119:
2120: or exists (select 'Y' from HZ_PARTY_SITES
2121: xx where xx.PARTY_ID = temp.party_id

Line 2124: (select 'Y' from AP_SUPPLIER_CONTACTS

2120: or exists (select 'Y' from HZ_PARTY_SITES
2121: xx where xx.PARTY_ID = temp.party_id
2122: and (nvl(STATUS, 'A') in ('A','I'))
2123: and exists
2124: (select 'Y' from AP_SUPPLIER_CONTACTS
2125: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2126: ));
2127: else
2128: delete from hz_purge_gt temp where

Line 2136: (select 'Y' from AP_SUPPLIER_CONTACTS

2132: xx where xx.OBJECT_ID = temp.party_id
2133: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2134: AND directional_flag = 'F')
2135: and exists
2136: (select 'Y' from AP_SUPPLIER_CONTACTS
2137: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2138: ))
2139: or exists (select 'Y' from HZ_RELATIONSHIPS
2140: xx where xx.PARTY_ID = temp.party_id

Line 2144: (select 'Y' from AP_SUPPLIER_CONTACTS

2140: xx where xx.PARTY_ID = temp.party_id
2141: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2142: AND directional_flag = 'F')
2143: and exists
2144: (select 'Y' from AP_SUPPLIER_CONTACTS
2145: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2146: ))
2147: or exists (select 'Y' from HZ_RELATIONSHIPS
2148: xx where xx.SUBJECT_ID = temp.party_id

Line 2152: (select 'Y' from AP_SUPPLIER_CONTACTS

2148: xx where xx.SUBJECT_ID = temp.party_id
2149: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2150: AND directional_flag = 'F')
2151: and exists
2152: (select 'Y' from AP_SUPPLIER_CONTACTS
2153: yy where yy.RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2154: ))
2155:
2156: or exists (select 'Y' from HZ_PARTY_SITES

Line 2164: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

2160: (select 'Y' from HZ_ORG_CONTACTS
2161: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2162: and nvl(STATUS, 'A') in ('A','I')
2163: and exists
2164: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2165: or exists (select 'Y' from HZ_RELATIONSHIPS
2166: xx where xx.OBJECT_ID = temp.party_id
2167: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2168: AND directional_flag = 'F')

Line 2174: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

2170: (select 'Y' from HZ_ORG_CONTACTS
2171: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2172: and nvl(STATUS, 'A') in ('A','I')
2173: and exists
2174: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2175: or exists (select 'Y' from HZ_RELATIONSHIPS
2176: xx where xx.PARTY_ID = temp.party_id
2177: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2178: AND directional_flag = 'F')

Line 2184: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

2180: (select 'Y' from HZ_ORG_CONTACTS
2181: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2182: and nvl(STATUS, 'A') in ('A','I')
2183: and exists
2184: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2185: or exists (select 'Y' from HZ_RELATIONSHIPS
2186: xx where xx.SUBJECT_ID = temp.party_id
2187: and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
2188: AND directional_flag = 'F')

Line 2194: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

2190: (select 'Y' from HZ_ORG_CONTACTS
2191: yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID
2192: and nvl(STATUS, 'A') in ('A','I')
2193: and exists
2194: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2195:
2196: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.PER_PARTY_ID = temp.party_id
2197: )
2198:

Line 2196: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.PER_PARTY_ID = temp.party_id

2192: and nvl(STATUS, 'A') in ('A','I')
2193: and exists
2194: (select 'Y' from AP_SUPPLIER_CONTACTS zz where zz.ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
2195:
2196: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.PER_PARTY_ID = temp.party_id
2197: )
2198:
2199: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.REL_PARTY_ID = temp.party_id
2200: )

Line 2199: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.REL_PARTY_ID = temp.party_id

2195:
2196: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.PER_PARTY_ID = temp.party_id
2197: )
2198:
2199: or exists (select 'Y' from AP_SUPPLIER_CONTACTS xx where xx.REL_PARTY_ID = temp.party_id
2200: )
2201:
2202: or exists (select 'Y' from HZ_PARTY_SITES
2203: xx where xx.PARTY_ID = temp.party_id

Line 2206: (select 'Y' from AP_SUPPLIER_CONTACTS

2202: or exists (select 'Y' from HZ_PARTY_SITES
2203: xx where xx.PARTY_ID = temp.party_id
2204: and (nvl(STATUS, 'A') in ('A','I'))
2205: and exists
2206: (select 'Y' from AP_SUPPLIER_CONTACTS
2207: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2208: ));
2209: end if;
2210: