[Home] [Help]
562: Now, the asset screens display information from TXL, as the contract status
563: is 'APPROVED'. As the above mentioned transaction failed, the line level
564: transaction invoked doesn't complete. Asset summary picks up the duplicate
565: assets. To avoid this, we are checking for object1_id1, object1_id2 values in
566: OKC_K_ITEMS. If they are populated, we treat is as a active contract else an
567: inactive one.
568:
569: This function checks whether the asset information of the contract exists in
570: FA, IB and TXL. If the information exists in FA, IB, then it is treated as a
587: /* FROM dual
588: WHERE exists
589: (SELECT (1) */
590: FROM OKC_K_LINES_B cle,
591: OKC_K_ITEMS itm,
592: OKC_LINE_STYLES_B lse,
593: OKC_STATUSES_B sts
594: WHERE cle.dnz_chr_id = p_dnz_chr_id
595: AND itm.dnz_chr_id = cle.dnz_chr_id
608: /* FROM dual
609: WHERE exists
610: (SELECT (1) */
611: FROM OKC_K_LINES_B cle,
612: OKC_K_ITEMS itm,
613: OKC_LINE_STYLES_B lse,
614: OKC_STATUSES_B sts
615: WHERE cle.dnz_chr_id = p_dnz_chr_id
616: AND itm.dnz_chr_id = cle.dnz_chr_id
629: /* FROM dual
630: WHERE exists
631: (SELECT (1) */
632: FROM OKC_K_LINES_B cle,
633: OKC_K_ITEMS itm,
634: OKC_LINE_STYLES_B lse,
635: OKC_STATUSES_B sts
636: WHERE cle.dnz_chr_id = p_dnz_chr_id
637: AND itm.dnz_chr_id = cle.dnz_chr_id
764: select cle_fin.id fin_line_id,
765: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null, null,null,null,null,null,null,'n','n',80,1,1),1,80) location_id
766: from hz_locations hl,
767: csi_item_instances csi,
768: okc_k_items cim_ib,
769: okc_line_styles_b lse_ib,
770: okc_k_lines_b cle_ib,
771: okc_line_styles_b lse_inst,
772: okc_k_lines_b cle_inst,
807: hz_party_sites hps,
808: --Bug# 3569441 :
809: --hz_party_site_uses hpsu,
810: csi_item_instances csi,
811: okc_k_items cim_ib,
812: okc_line_styles_b lse_ib,
813: okc_k_lines_b cle_ib,
814: okc_line_styles_b lse_inst,
815: okc_k_lines_b cle_inst,
1122: /*FROM dual
1123: WHERE exists
1124: (SELECT (1)*/
1125: FROM OKC_K_LINES_B cle,
1126: OKC_K_ITEMS itm,
1127: OKC_LINE_STYLES_B lse,
1128: OKC_STATUSES_B sts
1129: WHERE cle.dnz_chr_id = p_dnz_chr_id
1130: AND itm.dnz_chr_id = cle.dnz_chr_id