DBA Data[Home] [Help]

APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on CSP_RS_CUST_RELATIONS

Line 113: csp_rs_cust_relations ccr

109: hz_cust_acct_sites hzacs,
110: hz_cust_site_uses hzacus,
111: hz_parties hp,
112: hz_cust_accounts hzca,
113: csp_rs_cust_relations ccr
114: ,fnd_territories_vl t
115: where hzl.location_id =hps.location_id
116: and hzl.country = t.territory_code(+)
117: and hps.party_id=hp.party_id

Line 1616: FROM csp_rs_cust_relations csc

1612: hl.country,
1613: t.territory_short_name,
1614: HPS.START_DATE_ACTIVE,
1615: HPS.END_DATE_ACTIVE
1616: FROM csp_rs_cust_relations csc
1617: , hz_locations hl
1618: , fnd_territories_vl t
1619: , hz_party_sites hps
1620: WHERE csc.resource_id=p_resource_id