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.PV_MATCH_V2_PUB dependencies on HZ_PARTIES

Line 1288: l_where := l_where || ' , hz_parties PARTNER '

1284: -- Usage of SALES_PARTNER_FLAG has been obsoleted since 11.5.10
1285: -- -------------------------------------------------------------------------------
1286: if (isAm) then
1287:
1288: l_where := l_where || ' , hz_parties PARTNER '
1289: || ' where t.party_id = pvpp.partner_id '
1290: || ' and pvpp.partner_party_id = PARTNER.party_id '
1291: || ' and pvpp.status = ''A'' ';
1292:

Line 1306: l_where := l_where || ' , hz_parties partner '

1302:
1303: l_bind_count := l_bind_count + 1;
1304: l_bind_var_tbl(l_bind_count) := p_resource_id;
1305:
1306: l_where := l_where || ' , hz_parties partner '
1307: || ' where t.party_id = pvpp.partner_id '
1308: || ' and pvpp.partner_party_id = PARTNER.party_id '
1309: || ' and pvpp.status = ''A'' '
1310: || ' and pvpp.partner_party_id in ( select a.customer_id from as_accesses_all a '

Line 1320: || ' hz_relationships CONTACT_TO_VAD, hz_organization_profiles HZOP, hz_parties PARTNER '

1316: l_bind_count := l_bind_count + 1;
1317: l_bind_var_tbl(l_bind_count) := l_source_id;
1318:
1319: l_where := l_where || ' ,hz_relationships INDIRECT_TO_VAD, hz_relationships INDIRECT_TO_VENDOR, '
1320: || ' hz_relationships CONTACT_TO_VAD, hz_organization_profiles HZOP, hz_parties PARTNER '
1321: || ' where CONTACT_TO_VAD.party_id = :bv' || l_bind_count
1322: || ' and CONTACT_TO_VAD.object_id = INDIRECT_TO_VAD.object_id '
1323: || ' and CONTACT_TO_VAD.directional_flag = ''F'' '
1324: || ' and CONTACT_TO_VAD.subject_table_name = ''HZ_PARTIES'' '

Line 1324: || ' and CONTACT_TO_VAD.subject_table_name = ''HZ_PARTIES'' '

1320: || ' hz_relationships CONTACT_TO_VAD, hz_organization_profiles HZOP, hz_parties PARTNER '
1321: || ' where CONTACT_TO_VAD.party_id = :bv' || l_bind_count
1322: || ' and CONTACT_TO_VAD.object_id = INDIRECT_TO_VAD.object_id '
1323: || ' and CONTACT_TO_VAD.directional_flag = ''F'' '
1324: || ' and CONTACT_TO_VAD.subject_table_name = ''HZ_PARTIES'' '
1325: || ' and CONTACT_TO_VAD.object_table_name = ''HZ_PARTIES'' '
1326: || ' and CONTACT_TO_VAD.status = ''A'''
1327: || ' and CONTACT_TO_VAD.start_date <= sysdate '
1328: || ' and nvl(CONTACT_TO_VAD.end_date,sysdate) >= sysdate '

Line 1325: || ' and CONTACT_TO_VAD.object_table_name = ''HZ_PARTIES'' '

1321: || ' where CONTACT_TO_VAD.party_id = :bv' || l_bind_count
1322: || ' and CONTACT_TO_VAD.object_id = INDIRECT_TO_VAD.object_id '
1323: || ' and CONTACT_TO_VAD.directional_flag = ''F'' '
1324: || ' and CONTACT_TO_VAD.subject_table_name = ''HZ_PARTIES'' '
1325: || ' and CONTACT_TO_VAD.object_table_name = ''HZ_PARTIES'' '
1326: || ' and CONTACT_TO_VAD.status = ''A'''
1327: || ' and CONTACT_TO_VAD.start_date <= sysdate '
1328: || ' and nvl(CONTACT_TO_VAD.end_date,sysdate) >= sysdate '
1329: || ' and INDIRECT_TO_VAD.relationship_type = ''PARTNER_MANAGED_CUSTOMER'' '

Line 1330: || ' and INDIRECT_TO_VAD.subject_table_name = ''HZ_PARTIES'' '

1326: || ' and CONTACT_TO_VAD.status = ''A'''
1327: || ' and CONTACT_TO_VAD.start_date <= sysdate '
1328: || ' and nvl(CONTACT_TO_VAD.end_date,sysdate) >= sysdate '
1329: || ' and INDIRECT_TO_VAD.relationship_type = ''PARTNER_MANAGED_CUSTOMER'' '
1330: || ' and INDIRECT_TO_VAD.subject_table_name = ''HZ_PARTIES'' '
1331: || ' and INDIRECT_TO_VAD.object_table_name = ''HZ_PARTIES'' '
1332: || ' and INDIRECT_TO_VAD.subject_id = INDIRECT_TO_VENDOR.subject_id '
1333: || ' and INDIRECT_TO_VAD.status = ''A'''
1334: || ' and INDIRECT_TO_VAD.start_date <= sysdate '

Line 1331: || ' and INDIRECT_TO_VAD.object_table_name = ''HZ_PARTIES'' '

1327: || ' and CONTACT_TO_VAD.start_date <= sysdate '
1328: || ' and nvl(CONTACT_TO_VAD.end_date,sysdate) >= sysdate '
1329: || ' and INDIRECT_TO_VAD.relationship_type = ''PARTNER_MANAGED_CUSTOMER'' '
1330: || ' and INDIRECT_TO_VAD.subject_table_name = ''HZ_PARTIES'' '
1331: || ' and INDIRECT_TO_VAD.object_table_name = ''HZ_PARTIES'' '
1332: || ' and INDIRECT_TO_VAD.subject_id = INDIRECT_TO_VENDOR.subject_id '
1333: || ' and INDIRECT_TO_VAD.status = ''A'''
1334: || ' and INDIRECT_TO_VAD.start_date <= sysdate '
1335: || ' and nvl(INDIRECT_TO_VAD.end_date,sysdate) >= sysdate '

Line 1337: || ' and INDIRECT_TO_VENDOR.subject_table_name = ''HZ_PARTIES'' '

1333: || ' and INDIRECT_TO_VAD.status = ''A'''
1334: || ' and INDIRECT_TO_VAD.start_date <= sysdate '
1335: || ' and nvl(INDIRECT_TO_VAD.end_date,sysdate) >= sysdate '
1336: || ' and INDIRECT_TO_VENDOR.relationship_type =''PARTNER'' '
1337: || ' and INDIRECT_TO_VENDOR.subject_table_name = ''HZ_PARTIES'' '
1338: || ' and INDIRECT_TO_VENDOR.object_table_name = ''HZ_PARTIES'' '
1339: || ' and INDIRECT_TO_VENDOR.object_id = HZOP.party_id '
1340: || ' and INDIRECT_TO_VENDOR.status = ''A'''
1341: || ' and INDIRECT_TO_VENDOR.start_date <= sysdate '

Line 1338: || ' and INDIRECT_TO_VENDOR.object_table_name = ''HZ_PARTIES'' '

1334: || ' and INDIRECT_TO_VAD.start_date <= sysdate '
1335: || ' and nvl(INDIRECT_TO_VAD.end_date,sysdate) >= sysdate '
1336: || ' and INDIRECT_TO_VENDOR.relationship_type =''PARTNER'' '
1337: || ' and INDIRECT_TO_VENDOR.subject_table_name = ''HZ_PARTIES'' '
1338: || ' and INDIRECT_TO_VENDOR.object_table_name = ''HZ_PARTIES'' '
1339: || ' and INDIRECT_TO_VENDOR.object_id = HZOP.party_id '
1340: || ' and INDIRECT_TO_VENDOR.status = ''A'''
1341: || ' and INDIRECT_TO_VENDOR.start_date <= sysdate '
1342: || ' and nvl(INDIRECT_TO_VENDOR.end_date,sysdate) >= sysdate '

Line 2125: from hz_parties hzp , pv_partner_profiles pvpp , hz_parties vend,

2121: hzp.party_name,
2122: hzop_pt.internal_flag pt_int_flag,
2123: vend.party_name,
2124: hzop_vend.internal_flag vend_int_flag
2125: from hz_parties hzp , pv_partner_profiles pvpp , hz_parties vend,
2126: hz_relationships hzr,
2127: hz_organization_profiles HZOP_pt,
2128: hz_organization_profiles hzop_vend
2129: where hzr.party_id = pvpp.partner_id

Line 2132: and hzr.subject_table_name = 'HZ_PARTIES'

2128: hz_organization_profiles hzop_vend
2129: where hzr.party_id = pvpp.partner_id
2130: and pvpp.partner_party_id = hzr.subject_id
2131: and hzr.subject_id = hzp.party_id
2132: and hzr.subject_table_name = 'HZ_PARTIES'
2133: and hzr.object_table_name = 'HZ_PARTIES'
2134: and hzr.status = 'A' and hzr.start_date <= sysdate and nvl(hzr.end_date,sysdate) >= sysdate
2135: and hzr.subject_id = HZOP_pt.party_id and nvl(hzop_pt.effective_end_date,sysdate) >= sysdate
2136: and hzr.object_id = HZOP_vend.party_id and nvl(hzop_vend.effective_end_date,sysdate) >= sysdate

Line 2133: and hzr.object_table_name = 'HZ_PARTIES'

2129: where hzr.party_id = pvpp.partner_id
2130: and pvpp.partner_party_id = hzr.subject_id
2131: and hzr.subject_id = hzp.party_id
2132: and hzr.subject_table_name = 'HZ_PARTIES'
2133: and hzr.object_table_name = 'HZ_PARTIES'
2134: and hzr.status = 'A' and hzr.start_date <= sysdate and nvl(hzr.end_date,sysdate) >= sysdate
2135: and hzr.subject_id = HZOP_pt.party_id and nvl(hzop_pt.effective_end_date,sysdate) >= sysdate
2136: and hzr.object_id = HZOP_vend.party_id and nvl(hzop_vend.effective_end_date,sysdate) >= sysdate
2137: and (HZOP_vend.internal_flag = 'N' or hzop_pt.internal_flag = 'Y')

Line 2170: from hz_parties hzp , pv_partner_profiles pvpp ,

2166: and hzr.start_date <= SYSDATE and NVL(hzr.end_date,SYSDATE) >= SYSDATE
2167: then 'A'
2168: else 'I'
2169: end ) active_flag
2170: from hz_parties hzp , pv_partner_profiles pvpp ,
2171: pv_attribute_codes_vl pvac, hz_relationships hzr ,
2172: hz_organization_profiles HZOP,
2173: (SELECT rownum idx, column_value
2174: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner

Line 2181: and hzr.subject_table_name = 'HZ_PARTIES'

2177: and hzr.party_id = pvpp.partner_id
2178: and hzr.subject_id = hzp.party_id
2179: and hzr.object_id = HZOP.party_id
2180: and HZOP.internal_flag = 'Y'
2181: and hzr.subject_table_name = 'HZ_PARTIES'
2182: and hzr.object_table_name = 'HZ_PARTIES'
2183: and pvpp.PARTNER_LEVEL = pvac.attr_code_id(+)
2184: order by x_partner.idx;
2185:

Line 2182: and hzr.object_table_name = 'HZ_PARTIES'

2178: and hzr.subject_id = hzp.party_id
2179: and hzr.object_id = HZOP.party_id
2180: and HZOP.internal_flag = 'Y'
2181: and hzr.subject_table_name = 'HZ_PARTIES'
2182: and hzr.object_table_name = 'HZ_PARTIES'
2183: and pvpp.PARTNER_LEVEL = pvac.attr_code_id(+)
2184: order by x_partner.idx;
2185:
2186: -- 11.5.10 -- pklin

Line 2196: from hz_parties hzp,

2192: pvpp.partner_id,
2193: to_char(pvpp.OPPTY_LAST_OFFERED_DATE, 'YYYY-MM-DD HH:MM:SS'),
2194: pvac.description,
2195: pvpp.status active_flag
2196: from hz_parties hzp,
2197: pv_partner_profiles pvpp,
2198: pv_attribute_codes_vl pvac,
2199: (SELECT rownum idx, column_value
2200: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner

Line 2213: hz_parties hzp,

2209: /* CURSOR lc_get_pt_org_name(lc_partner_id NUMBER)
2210: IS
2211: select distinct party_name
2212: from hz_relationships hzr,
2213: hz_parties hzp,
2214: hz_organization_profiles HZOP
2215: where hzr.subject_id = hzp.party_id
2216: and hzr.object_id = HZOP.party_id
2217: and HZOP.internal_flag = 'Y'

Line 2218: and hzr.subject_table_name = 'HZ_PARTIES'

2214: hz_organization_profiles HZOP
2215: where hzr.subject_id = hzp.party_id
2216: and hzr.object_id = HZOP.party_id
2217: and HZOP.internal_flag = 'Y'
2218: and hzr.subject_table_name = 'HZ_PARTIES'
2219: and hzr.object_table_name = 'HZ_PARTIES'
2220: and hzr.party_id = lc_partner_id; */
2221:
2222: l_pt_id NUMBER;

Line 2219: and hzr.object_table_name = 'HZ_PARTIES'

2215: where hzr.subject_id = hzp.party_id
2216: and hzr.object_id = HZOP.party_id
2217: and HZOP.internal_flag = 'Y'
2218: and hzr.subject_table_name = 'HZ_PARTIES'
2219: and hzr.object_table_name = 'HZ_PARTIES'
2220: and hzr.party_id = lc_partner_id; */
2221:
2222: l_pt_id NUMBER;
2223: l_pt_count NUMBER;

Line 2285: 'from hz_parties hzp , pv_partner_profiles pvpp, pv_attribute_codes_tl pvac, '||

2281: 'hzp.postal_code, hzp.country, hzp.address1, hzp.address2, hzp.address3, '||
2282: 'hzp.party_id, pvpp.partner_id, pvac.description, '||
2283: 'to_char(pvpp.oppty_last_offered_date, ''YYYY-MM-DD HH:MI:SS''), '||
2284: 'pvpp.status active_flag ' ||
2285: 'from hz_parties hzp , pv_partner_profiles pvpp, pv_attribute_codes_tl pvac, '||
2286: '(SELECT rownum idx, column_value FROM '||
2287: '(SELECT column_value FROM TABLE (CAST(:1 AS JTF_NUMBER_TABLE)))) x_partner '||
2288: 'where pvpp.partner_id = x_partner.column_value ' ||
2289: 'and pvpp.partner_party_id = hzp.party_id ' ||

Line 2709: hz_parties pt

2705: select
2706: pr.relationship_type,
2707: pr.object_id
2708: from hz_relationships pr,
2709: hz_parties pt
2710: where pr.party_id = pc_party_rel_id
2711: AND pr.subject_table_name = 'HZ_PARTIES'
2712: AND pr.object_table_name = 'HZ_PARTIES'
2713: AND pr.directional_flag = 'F'

Line 2711: AND pr.subject_table_name = 'HZ_PARTIES'

2707: pr.object_id
2708: from hz_relationships pr,
2709: hz_parties pt
2710: where pr.party_id = pc_party_rel_id
2711: AND pr.subject_table_name = 'HZ_PARTIES'
2712: AND pr.object_table_name = 'HZ_PARTIES'
2713: AND pr.directional_flag = 'F'
2714: and pr.subject_id = pt.party_id;
2715:

Line 2712: AND pr.object_table_name = 'HZ_PARTIES'

2708: from hz_relationships pr,
2709: hz_parties pt
2710: where pr.party_id = pc_party_rel_id
2711: AND pr.subject_table_name = 'HZ_PARTIES'
2712: AND pr.object_table_name = 'HZ_PARTIES'
2713: AND pr.directional_flag = 'F'
2714: and pr.subject_id = pt.party_id;
2715:
2716: