APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on HZ_PARTY_SITE_USES

Line 1074: --hz_party_site_uses cust_party_site_use,

1070: okx_salesreps_v sales_rep,
1071: xle_entity_profiles legal_entity,
1072:
1073: hz_party_sites cust_party_site,
1074: --hz_party_site_uses cust_party_site_use,
1075: --hz_cust_site_uses_all cust_cust_site_use,
1076: hz_cust_acct_sites_all cust_cust_acct_site,
1077: -- hz_party_site_uses cust_party_site_use,
1078: (select cpsu_party_site_use_id,

Line 1077: -- hz_party_site_uses cust_party_site_use,

1073: hz_party_sites cust_party_site,
1074: --hz_party_site_uses cust_party_site_use,
1075: --hz_cust_site_uses_all cust_cust_site_use,
1076: hz_cust_acct_sites_all cust_cust_acct_site,
1077: -- hz_party_site_uses cust_party_site_use,
1078: (select cpsu_party_site_use_id,
1079: cpsu_party_site_id,
1080: cpsu_SITE_USE_TYPE,
1081: cpsu_status,

Line 1092: from hz_party_site_uses cust_party_site_use_n

1088: cust_party_site_use_n.status cpsu_status,
1089: cust_party_site_use_n.comments cpsu_comments,
1090: row_number() over ( partition by cust_party_site_use_n.party_site_id
1091: order by NVL(cust_party_site_use_n.status,'A') ASC) cpsu_stat_priority
1092: from hz_party_site_uses cust_party_site_use_n
1093: where cust_party_site_use_n.SITE_USE_TYPE = 'BILL_TO'
1094: ) where cpsu_stat_priority = 1) cust_party_site_use,
1095:
1096: hz_cust_site_uses_all cust_cust_site_use,

Line 2105: -- hz_party_site_uses cust_party_site_use,

2101: xle_entity_profiles legal_entity,
2102:
2103:
2104: hz_party_sites cust_party_site,
2105: -- hz_party_site_uses cust_party_site_use,
2106: (select cpsu_party_site_use_id,
2107: cpsu_party_site_id,
2108: cpsu_SITE_USE_TYPE,
2109: cpsu_status,

Line 2120: from hz_party_site_uses cust_party_site_use_n

2116: cust_party_site_use_n.status cpsu_status,
2117: cust_party_site_use_n.comments cpsu_comments,
2118: row_number() over ( partition by cust_party_site_use_n.party_site_id
2119: order by NVL(cust_party_site_use_n.status,'A') ASC) cpsu_stat_priority
2120: from hz_party_site_uses cust_party_site_use_n
2121: where cust_party_site_use_n.SITE_USE_TYPE = 'BILL_TO'
2122: ) where cpsu_stat_priority = 1) cust_party_site_use,
2123:
2124: hz_cust_site_uses_all cust_cust_site_use,