[Home] [Help]
182: hzl.time_zone
183: from csp_rs_cust_relations rcr,
184: hz_cust_acct_sites cas,
185: hz_cust_site_uses csu,
186: po_location_associations pla,
187: hz_party_sites ps,
188: hz_locations hzl
189: where rcr.customer_id = cas.cust_account_id
190: and cas.cust_acct_site_id = csu.cust_acct_site_id (+)
201: hzl.time_zone timezone_id
202: from csp_rs_cust_relations rcr,
203: hz_cust_acct_sites cas,
204: hz_cust_site_uses csu,
205: po_location_associations pla,
206: hz_party_sites ps,
207: hz_locations hzl,
208: jtf_task_assignments jta
209: where rcr.customer_id = cas.cust_account_id
354: SELECT hzl.time_zone time_zone_id
355: INTO l_timezone_id
356: from hz_cust_acct_sites cas,
357: hz_cust_site_uses csu,
358: po_location_associations pla,
359: hz_party_sites ps,
360: hz_locations hzl
361: where cas.cust_acct_site_id = csu.cust_acct_site_id (+)
362: and csu.site_use_code = 'SHIP_TO'
4182: cs_incidents_all_b cia,
4183: jtf_tasks_b jtb,
4184: hz_cust_site_uses_all hcsu,
4185: hz_cust_acct_sites_all hcas,
4186: po_location_associations_all pa,
4187: jtf_task_assignments jta
4188: WHERE jta.task_assignment_id = l_Task_Assignment_id
4189: AND jtb.task_id = jta.task_id
4190: AND jtb.source_object_type_code = 'SR'
4212: cs_incidents_all_b cia,
4213: jtf_tasks_b jtb,
4214: hz_cust_site_uses_all hcsu,
4215: hz_cust_acct_sites_all hcas,
4216: po_location_associations_all pa,
4217: jtf_task_assignments jta
4218: WHERE jta.task_assignment_id = l_Task_Assignment_id
4219: AND jtb.task_id = jta.task_id
4220: AND jtb.source_object_type_code = 'SR'