[Home] [Help]
5800: if l_location_source_code = 'HZ' then
5801: select hzp.party_name
5802: into l_owner_name
5803: from hz_cust_accounts hzc,
5804: hz_parties hzp
5805: where hzc.cust_account_id = p_customer_id
5806: and hzc.party_id = hzp.party_id;
5807:
5808: -- p_party_id is orgnization_id from mst_delivery_details
5831: from hz_locations hzl,
5832: hz_party_sites hzs,
5833: hz_cust_acct_sites_all hzcas,
5834: hz_cust_accounts hzca,
5835: hz_parties hzp,
5836: mst_deliveries md
5837: where md.plan_id = p_plan_id
5838: AND md.delivery_id = p_delivery_id
5839: and hzl.location_id = p_location_id
5846: cursor carriers is
5847: select car.freight_code
5848: from hz_locations hzl,
5849: hz_party_sites hzs,
5850: hz_parties hzp,
5851: wsh_carriers car
5852: where hzl.location_id = p_location_id
5853: and hzl.location_id = hzs.location_id
5854: and hzs.party_id = hzp.party_id
5885: -- SQL repository issues as on 25-05-04:
5886: -- Rewritten sql to avoid distinct clause
5887: CURSOR customer_account IS
5888: SELECT hzp.party_name
5889: FROM hz_parties hzp
5890: WHERE hzp.party_id IN (SELECT hzca.party_id
5891: FROM hz_locations hzl , hz_party_sites hzs,
5892: hz_cust_acct_sites_all hzcas, hz_cust_accounts hzca
5893: WHERE hzl.location_id = p_location_id
5901: from hz_locations hzl,
5902: hz_party_sites hzs,
5903: hz_cust_acct_sites_all hzcas,
5904: hz_cust_accounts hzca,
5905: hz_parties hzp
5906: where hzl.location_id = p_location_id
5907: and hzl.location_id = hzs.location_id
5908: and hzs.party_site_id = hzcas.party_site_id
5909: and hzcas.cust_account_id = hzca.cust_account_id
5912: cursor carriers is
5913: select car.freight_code
5914: from hz_locations hzl,
5915: hz_party_sites hzs,
5916: hz_parties hzp,
5917: wsh_carriers car
5918: where hzl.location_id = p_location_id
5919: and hzl.location_id = hzs.location_id
5920: and hzs.party_id = hzp.party_id