APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on HZ_PARTIES

Line 90: hz_parties hp ,

86: okch.authoring_org_id
87: From ahl_unit_effectivities_app_v aueb,
88: csi_item_instances csi,
89: ahl_mr_headers_vl amh,
90: hz_parties hp ,
91: okc_k_lines_b okcl,
92: okc_k_headers_all_b okch
93: Where nvl(aueb.earliest_due_date,aueb.due_date) <= trunc(sysdate) + p_period_size
94: -- Get only the open UMPs and SR not created

Line 128: Hz_Parties hp_obj,

124: decode(primary_flag,'Y','Y',NULL)
125: primary_contact,
126: timezone_id
127: From Hz_Relationships hr,
128: Hz_Parties hp_obj,
129: Hz_Parties hp_sub,
130: Hz_Contact_points hcp
131: Where hr.object_id = p_party_id
132: and hr.status = 'A'

Line 129: Hz_Parties hp_sub,

125: primary_contact,
126: timezone_id
127: From Hz_Relationships hr,
128: Hz_Parties hp_obj,
129: Hz_Parties hp_sub,
130: Hz_Contact_points hcp
131: Where hr.object_id = p_party_id
132: and hr.status = 'A'
133: and NVL(hr.start_date, SYSDATE-1) < SYSDATE

Line 142: and hcp.owner_table_name(+) = 'HZ_PARTIES'

138: and hp_obj.party_id = hr.object_id
139: and hp_obj.status = 'A'
140: and hp_obj.party_type = 'ORGANIZATION'
141: and hcp.owner_table_id(+) = hr.party_id
142: and hcp.owner_table_name(+) = 'HZ_PARTIES'
143: and hcp.status(+) = 'A'
144: and hr.party_id is not null;
145:
146: cursor c_billto_shipto(p_billto_party NUMBER,p_shipto_party NUMBER) is

Line 148: from hz_relationships hr,hz_parties hp

144: and hr.party_id is not null;
145:
146: cursor c_billto_shipto(p_billto_party NUMBER,p_shipto_party NUMBER) is
147: select hr.object_id,max(hr.party_id) party_id
148: from hz_relationships hr,hz_parties hp
149: where hr.object_id in (p_billto_party,p_shipto_party)
150: AND hr.status = 'A'
151: AND NVL(hr.start_date, SYSDATE-1) < SYSDATE
152: AND NVL(hr.end_date, SYSDATE+1) > SYSDATE