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