APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on HZ_PARTY_SITE_USES

Line 1060: --hz_party_site_uses cust_party_site_use,

1056: okx_salesreps_v sales_rep,
1057: xle_entity_profiles legal_entity,
1058:
1059: hz_party_sites cust_party_site,
1060: --hz_party_site_uses cust_party_site_use,
1061: --hz_cust_site_uses_all cust_cust_site_use,
1062: hz_cust_acct_sites_all cust_cust_acct_site,
1063: -- hz_party_site_uses cust_party_site_use,
1064: (select cpsu_party_site_use_id,

Line 1063: -- hz_party_site_uses cust_party_site_use,

1059: hz_party_sites cust_party_site,
1060: --hz_party_site_uses cust_party_site_use,
1061: --hz_cust_site_uses_all cust_cust_site_use,
1062: hz_cust_acct_sites_all cust_cust_acct_site,
1063: -- hz_party_site_uses cust_party_site_use,
1064: (select cpsu_party_site_use_id,
1065: cpsu_party_site_id,
1066: cpsu_SITE_USE_TYPE,
1067: cpsu_status,

Line 1078: from hz_party_site_uses cust_party_site_use_n

1074: cust_party_site_use_n.status cpsu_status,
1075: cust_party_site_use_n.comments cpsu_comments,
1076: row_number() over ( partition by cust_party_site_use_n.party_site_id
1077: order by NVL(cust_party_site_use_n.status,'A') ASC) cpsu_stat_priority
1078: from hz_party_site_uses cust_party_site_use_n
1079: where cust_party_site_use_n.SITE_USE_TYPE = 'BILL_TO'
1080: ) where cpsu_stat_priority = 1) cust_party_site_use,
1081:
1082: hz_cust_site_uses_all cust_cust_site_use,

Line 2091: -- hz_party_site_uses cust_party_site_use,

2087: xle_entity_profiles legal_entity,
2088:
2089:
2090: hz_party_sites cust_party_site,
2091: -- hz_party_site_uses cust_party_site_use,
2092: (select cpsu_party_site_use_id,
2093: cpsu_party_site_id,
2094: cpsu_SITE_USE_TYPE,
2095: cpsu_status,

Line 2106: from hz_party_site_uses cust_party_site_use_n

2102: cust_party_site_use_n.status cpsu_status,
2103: cust_party_site_use_n.comments cpsu_comments,
2104: row_number() over ( partition by cust_party_site_use_n.party_site_id
2105: order by NVL(cust_party_site_use_n.status,'A') ASC) cpsu_stat_priority
2106: from hz_party_site_uses cust_party_site_use_n
2107: where cust_party_site_use_n.SITE_USE_TYPE = 'BILL_TO'
2108: ) where cpsu_stat_priority = 1) cust_party_site_use,
2109:
2110: hz_cust_site_uses_all cust_cust_site_use,