DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on CSP_RS_CUST_RELATIONS

Line 1449: from csp_rs_cust_relations rcr,

1445: -- Bug 14494663 - Not required as in case of special ship address as we cannot create address
1446: /* CURSOR rs_loc_exists_cur(p_inv_loc_id NUMBER, p_resource_id NUMBER, p_resource_type VARCHAR2) IS
1447:
1448: SELECT ps.location_id site_loc_id
1449: from csp_rs_cust_relations rcr,
1450: hz_cust_acct_sites cas,
1451: hz_cust_site_uses csu,
1452: po_location_associations pla,
1453: hz_party_sites ps

Line 1507: csp_rs_cust_relations cr,

1503:
1504: cursor get_res_primary_bill_to(p_resource_id NUMBER, p_resource_type VARCHAR2) IS
1505: select csu.site_use_id
1506: from
1507: csp_rs_cust_relations cr,
1508: hz_cust_acct_sites cas,
1509: hz_cust_site_uses csu
1510: where
1511: cr.resource_type = p_resource_type