eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKC_STATUS_CHANGE_PVT dependencies on OKC_STATUSES_V

Line 31: from okc_statuses_v

27: v_signed_m VARCHAR2(90) := 'Signed';
28:
29: cursor sts(p_status_type varchar2) is
30: select code, meaning
31: from okc_statuses_v
32: where ste_code = p_status_type
33: and default_yn = 'Y';
34:
35:

Line 363: meaning okc_statuses_v.meaning%TYPE);

359: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
360: TERMINATION_REASON fnd_lookups.meaning%TYPE,
361: CODE okc_statuses_b.code%TYPE,
362: STE_CODE okc_statuses_b.ste_code%TYPE,
363: meaning okc_statuses_v.meaning%TYPE);
364:
365: line_rec line_rec_type;
366: r_terminate_line_rec line_rec_type;
367: r_expired_line_rec line_rec_type;

Line 429: OKC_STATUSES_V status,

425: status.CODE,
426: status.STE_CODE,
427: status.meaning
428: FROM OKC_K_LINES_B line,
429: OKC_STATUSES_V status,
430: fnd_lookups fnd,
431: okc_k_headers_b chr,
432: okc_subclasses_b scs
433: WHERE line.STS_CODE = status.CODE

Line 564: OKC_STATUSES_V status,

560: status.CODE,
561: status.STE_CODE,
562: status.meaning
563: FROM OKC_K_LINES_B line,
564: OKC_STATUSES_V status,
565: OKC_K_HEADERS_B chr,
566: okc_subclasses_b scs
567: WHERE line.STS_CODE = status.CODE
568: AND line.dnz_chr_id = chr.id

Line 656: -- OKC_STATUSES_V status,

652: stsb.CODE,
653: stsb.STE_CODE,
654: stst.meaning
655: FROM OKC_K_LINES_B line,
656: -- OKC_STATUSES_V status,
657: OKC_STATUSES_TL stst,
658: OKC_STATUSES_B stsb,
659: OKC_K_HEADERS_B chr
660: -- okc_subclasses_b scs

Line 741: OKC_STATUSES_V status,

737: status.CODE,
738: status.STE_CODE,
739: status.meaning
740: FROM OKC_K_LINES_B line,
741: OKC_STATUSES_V status,
742: OKC_STATUSES_B status1,
743: okc_k_headers_b chr,
744: okc_subclasses_b scs
745: WHERE line.STS_CODE = status.CODE

Line 785: OKC_STATUSES_V status,

781: status.CODE,
782: status.STE_CODE,
783: status.meaning
784: FROM OKC_K_LINES_B line,
785: OKC_STATUSES_V status,
786: OKC_STATUSES_B status1,
787: okc_k_headers_b chr,
788: okc_subclasses_b scs
789: WHERE line.STS_CODE = status.CODE

Line 824: OKC_STATUSES_V status,

820: status.CODE,
821: status.STE_CODE,
822: status.meaning
823: FROM OKC_K_LINES_B line,
824: OKC_STATUSES_V status,
825: OKC_STATUSES_B status1,
826: okc_k_headers_b chr,
827: okc_subclasses_b scs
828: WHERE line.STS_CODE = status.CODE

Line 859: OKC_STATUSES_V status,

855: status.CODE,
856: status.STE_CODE,
857: status.meaning
858: FROM OKC_K_LINES_B line,
859: OKC_STATUSES_V status,
860: OKC_STATUSES_B status1,
861: okc_k_headers_b chr,
862: okc_subclasses_b scs
863: WHERE line.STS_CODE = status.CODE

Line 897: OKC_STATUSES_V status,

893: status.CODE,
894: status.STE_CODE,
895: status.meaning
896: FROM OKC_K_LINES_B line,
897: OKC_STATUSES_V status,
898: OKC_STATUSES_B status1,
899: okc_k_headers_b chr,
900: okc_subclasses_b scs
901: WHERE line.STS_CODE = status.CODE

Line 936: OKC_STATUSES_V status,

932: status.CODE,
933: status.STE_CODE,
934: status.meaning
935: FROM OKC_K_LINES_B line,
936: OKC_STATUSES_V status,
937: OKC_STATUSES_B status1,
938: okc_k_headers_b chr,
939: okc_subclasses_b scs
940: WHERE line.STS_CODE = status.CODE

Line 971: OKC_STATUSES_V status,

967: status.CODE,
968: status.STE_CODE,
969: status.meaning
970: FROM OKC_K_LINES_B line,
971: OKC_STATUSES_V status,
972: OKC_STATUSES_B status1,
973: okc_k_headers_b chr,
974: okc_subclasses_b scs
975: WHERE line.STS_CODE = status.CODE

Line 1004: OKC_STATUSES_V status,

1000: status.CODE,
1001: status.STE_CODE,
1002: status.meaning
1003: FROM OKC_K_LINES_B line,
1004: OKC_STATUSES_V status,
1005: fnd_lookups fnd
1006: WHERE line.STS_CODE = status.CODE
1007: AND line.dnz_chr_id = p_kid
1008: --BUG 4915692 --

Line 1032: OKC_STATUSES_V status

1028: status.CODE,
1029: status.STE_CODE,
1030: status.meaning
1031: FROM OKC_K_LINES_B line,
1032: OKC_STATUSES_V status
1033: WHERE line.STS_CODE = status.CODE
1034: AND line.dnz_chr_id = p_kid
1035: --BUG 4915692 --
1036: --AND STATUS.STE_CODE IN ('ACTIVE','HOLD','SIGNED')

Line 1064: OKC_STATUSES_V status

1060: status.CODE,
1061: status.STE_CODE,
1062: status.meaning
1063: FROM OKC_K_LINES_B line,
1064: OKC_STATUSES_V status
1065: WHERE line.STS_CODE = status.CODE
1066: AND line.dnz_chr_id = p_kid
1067: AND status.ste_code = 'SIGNED'
1068: AND line.start_date >= trunc(l_last_rundate) AND

Line 1089: OKC_STATUSES_V status

1085: status.CODE,
1086: status.STE_CODE,
1087: status.meaning
1088: FROM OKC_K_LINES_B line,
1089: OKC_STATUSES_V status
1090: WHERE line.STS_CODE = status.CODE
1091: AND line.dnz_chr_id = p_kid
1092: AND status.ste_code = 'ACTIVE'
1093: AND line.start_date >= trunc(l_last_rundate) AND

Line 3087: OKC_STATUSES_V status,

3083: status.CODE,
3084: status.STE_CODE,
3085: status.meaning
3086: FROM OKC_K_HEADERS_B hdr,
3087: OKC_STATUSES_V status,
3088: OKC_SUBCLASSES_B scs
3089: WHERE hdr.STS_CODE = status.CODE
3090: AND scs.code = hdr.scs_code
3091: and scs.cls_code <> 'OKL'

Line 3126: OKC_STATUSES_V status,

3122: status.CODE,
3123: status.STE_CODE,
3124: status.meaning
3125: FROM OKC_K_HEADERS_B hdr,
3126: OKC_STATUSES_V status,
3127: OKC_SUBCLASSES_B scs
3128: WHERE hdr.STS_CODE = status.CODE
3129: AND scs.code = hdr.scs_code
3130: and scs.cls_code <> 'OKL'

Line 3165: OKC_STATUSES_V status,

3161: status.CODE,
3162: status.STE_CODE,
3163: status.meaning
3164: FROM OKC_K_HEADERS_B hdr,
3165: OKC_STATUSES_V status,
3166: OKC_SUBCLASSES_B scs
3167: WHERE hdr.STS_CODE = status.CODE
3168: AND scs.code = hdr.scs_code
3169: and scs.cls_code <> 'OKL'

Line 3209: OKC_STATUSES_V status,

3205: status.CODE,
3206: status.STE_CODE,
3207: status.meaning
3208: FROM OKC_K_HEADERS_B hdr,
3209: OKC_STATUSES_V status,
3210: FND_LOOKUPS fnd,
3211: OKC_SUBCLASSES_B scs
3212: WHERE hdr.STS_CODE = status.CODE
3213: AND scs.code = hdr.scs_code