[Home] [Help]
535: Now, the asset screens display information from TXL, as the contract status
536: is 'APPROVED'. As the above mentioned transaction failed, the line level
537: transaction invoked doesn't complete. Asset summary picks up the duplicate
538: assets. To avoid this, we are checking for object1_id1, object1_id2 values in
539: OKC_K_ITEMS. If they are populated, we treat is as a active contract else an
540: inactive one.
541:
542: This function checks whether the asset information of the contract exists in
543: FA, IB and TXL. If the information exists in FA, IB, then it is treated as a
560: /* FROM dual
561: WHERE exists
562: (SELECT (1) */
563: FROM OKC_K_LINES_B cle,
564: OKC_K_ITEMS itm,
565: OKC_LINE_STYLES_B lse,
566: OKC_STATUSES_B sts
567: WHERE cle.dnz_chr_id = p_dnz_chr_id
568: AND itm.dnz_chr_id = cle.dnz_chr_id
581: /* FROM dual
582: WHERE exists
583: (SELECT (1) */
584: FROM OKC_K_LINES_B cle,
585: OKC_K_ITEMS itm,
586: OKC_LINE_STYLES_B lse,
587: OKC_STATUSES_B sts
588: WHERE cle.dnz_chr_id = p_dnz_chr_id
589: AND itm.dnz_chr_id = cle.dnz_chr_id
602: /* FROM dual
603: WHERE exists
604: (SELECT (1) */
605: FROM OKC_K_LINES_B cle,
606: OKC_K_ITEMS itm,
607: OKC_LINE_STYLES_B lse,
608: OKC_STATUSES_B sts
609: WHERE cle.dnz_chr_id = p_dnz_chr_id
610: AND itm.dnz_chr_id = cle.dnz_chr_id
736: select cle_fin.id fin_line_id,
737: 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
738: from hz_locations hl,
739: csi_item_instances csi,
740: okc_k_items cim_ib,
741: okc_line_styles_b lse_ib,
742: okc_k_lines_b cle_ib,
743: okc_line_styles_b lse_inst,
744: okc_k_lines_b cle_inst,
779: hz_party_sites hps,
780: --Bug# 3569441 :
781: --hz_party_site_uses hpsu,
782: csi_item_instances csi,
783: okc_k_items cim_ib,
784: okc_line_styles_b lse_ib,
785: okc_k_lines_b cle_ib,
786: okc_line_styles_b lse_inst,
787: okc_k_lines_b cle_inst,
1094: /*FROM dual
1095: WHERE exists
1096: (SELECT (1)*/
1097: FROM OKC_K_LINES_B cle,
1098: OKC_K_ITEMS itm,
1099: OKC_LINE_STYLES_B lse,
1100: OKC_STATUSES_B sts
1101: WHERE cle.dnz_chr_id = p_dnz_chr_id
1102: AND itm.dnz_chr_id = cle.dnz_chr_id