[Home] [Help]
1448:
1449: -- cusotmer
1450: HZ_PARTIES cust_party,
1451: HZ_CUST_ACCOUNTS cust_accounts,
1452: hz_party_sites cust_party_site,
1453: (select cpsu_party_site_use_id,
1454: cpsu_party_site_id,
1455: cpsu_SITE_USE_TYPE,
1456: cpsu_status,
1641: okc_k_party_roles_b cpl,
1642: po_vendors pov,
1643: okc_k_lines_b cle,
1644: hz_locations hl,
1645: hz_party_sites hps,
1646: hz_cust_acct_sites_all cas,
1647: hz_cust_site_uses_all csu
1648: WHERE inv.cle_id (+)= cpl.cle_id
1649: AND cpl.rle_code = 'OKL_VENDOR'
1743: lookup.MEANING MULTIPLE,
1744: row_number() over ( partition by cle_inst.cle_id
1745: order by iti.object_id1_new nulls last ) instal_site_row_num
1746: from hz_locations hl,
1747: hz_party_sites hps,
1748: okl_txl_itm_insts iti,
1749: csi_item_instances csi,
1750: okc_k_items cim_ib,
1751: okc_k_lines_b cle_ib,
1761: and cim_ib.object1_id1 = csi.instance_id
1762: and cim_ib.object1_id2 = '#'
1763: and cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
1764: and csi.install_location_id = hps.party_site_id
1765: and csi.install_location_type_code = 'HZ_PARTY_SITES'
1766: and hps.location_id = hl.location_id
1767: and lookup.lookup_type like 'OKL_ECC_VALUE_TYPE'
1768: and lookup.lookup_code like 'MULTIPLE')
1769: where instal_site_row_num = 1
3563:
3564: -- cusotmer
3565: HZ_PARTIES cust_party,
3566: HZ_CUST_ACCOUNTS cust_accounts,
3567: hz_party_sites cust_party_site,
3568: (select cpsu_party_site_use_id,
3569: cpsu_party_site_id,
3570: cpsu_SITE_USE_TYPE,
3571: cpsu_status,
3752: okc_k_party_roles_b cpl,
3753: po_vendors pov,
3754: okc_k_lines_b cle,
3755: hz_locations hl,
3756: hz_party_sites hps,
3757: hz_cust_acct_sites_all cas,
3758: hz_cust_site_uses_all csu
3759: WHERE inv.cle_id (+)= cpl.cle_id
3760: AND cpl.rle_code = 'OKL_VENDOR'
3857: FROM okc_k_lines_b cleb_inst,
3858: okc_k_lines_b cleb_ib,
3859: okl_txl_itm_insts iti,
3860: hz_locations hl,
3861: hz_party_sites hps,
3862: hz_party_site_uses hpu,
3863: fnd_lookup_values_vl lookup
3864: WHERE cleb_inst.lse_id = 43
3865: AND cleb_ib.cle_id = cleb_inst.id
5588:
5589: -- cusotmer
5590: HZ_PARTIES cust_party,
5591: HZ_CUST_ACCOUNTS cust_accounts,
5592: hz_party_sites cust_party_site,
5593: (select cpsu_party_site_use_id,
5594: cpsu_party_site_id,
5595: cpsu_SITE_USE_TYPE,
5596: cpsu_status,
5733: okc_k_party_roles_b cpl,
5734: po_vendors pov,
5735: okc_k_lines_b cle,
5736: hz_locations hl,
5737: hz_party_sites hps,
5738: hz_cust_acct_sites_all cas,
5739: hz_cust_site_uses_all csu
5740: WHERE inv.cle_id (+)= cpl.cle_id
5741: AND cpl.rle_code = 'OKL_VENDOR'
5837: lookup.MEANING MULTIPLE,
5838: row_number() over ( partition by cle_inst.cle_id
5839: order by iti.object_id1_new nulls last ) instal_site_row_num
5840: from hz_locations hl,
5841: hz_party_sites hps,
5842: okl_txl_itm_insts iti,
5843: csi_item_instances csi,
5844: okc_k_items cim_ib,
5845: okc_k_lines_b cle_ib,
5855: and cim_ib.object1_id1 = csi.instance_id
5856: and cim_ib.object1_id2 = '#'
5857: and cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
5858: and csi.install_location_id = hps.party_site_id
5859: and csi.install_location_type_code = 'HZ_PARTY_SITES'
5860: and hps.location_id = hl.location_id
5861: and lookup.lookup_type like 'OKL_ECC_VALUE_TYPE'
5862: and lookup.lookup_code like 'MULTIPLE')
5863: where instal_site_row_num = 1
5892: FROM okc_k_lines_b cleb_inst,
5893: okc_k_lines_b cleb_ib,
5894: okl_txl_itm_insts iti,
5895: hz_locations hl,
5896: hz_party_sites hps,
5897: hz_party_site_uses hpu,
5898: fnd_lookup_values_vl lookup
5899: WHERE cleb_inst.lse_id = 43
5900: AND cleb_ib.cle_id = cleb_inst.id