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 377: meaning okc_statuses_v.meaning%TYPE);

373: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
374: TERMINATION_REASON fnd_lookups.meaning%TYPE,
375: CODE okc_statuses_b.code%TYPE,
376: STE_CODE okc_statuses_b.ste_code%TYPE,
377: meaning okc_statuses_v.meaning%TYPE);
378:
379: line_rec line_rec_type;
380: r_terminate_line_rec line_rec_type;
381: r_expired_line_rec line_rec_type;

Line 443: OKC_STATUSES_V status,

439: status.CODE,
440: status.STE_CODE,
441: status.meaning
442: FROM OKC_K_LINES_B line,
443: OKC_STATUSES_V status,
444: fnd_lookups fnd,
445: okc_k_headers_b chr,
446: okc_subclasses_b scs
447: WHERE line.STS_CODE = status.CODE

Line 584: OKC_STATUSES_V status,

580: status.CODE,
581: status.STE_CODE,
582: status.meaning
583: FROM OKC_K_LINES_B line,
584: OKC_STATUSES_V status,
585: OKC_K_HEADERS_B chr,
586: okc_subclasses_b scs
587: WHERE line.STS_CODE = status.CODE
588: AND line.dnz_chr_id = chr.id

Line 676: -- OKC_STATUSES_V status,

672: stsb.CODE,
673: stsb.STE_CODE,
674: stst.meaning
675: FROM OKC_K_LINES_B line,
676: -- OKC_STATUSES_V status,
677: OKC_STATUSES_TL stst,
678: OKC_STATUSES_B stsb,
679: OKC_K_HEADERS_B chr
680: -- okc_subclasses_b scs

Line 761: OKC_STATUSES_V status,

757: status.CODE,
758: status.STE_CODE,
759: status.meaning
760: FROM OKC_K_LINES_B line,
761: OKC_STATUSES_V status,
762: OKC_STATUSES_B status1,
763: okc_k_headers_b chr,
764: okc_subclasses_b scs
765: WHERE line.STS_CODE = status.CODE

Line 805: OKC_STATUSES_V status,

801: status.CODE,
802: status.STE_CODE,
803: status.meaning
804: FROM OKC_K_LINES_B line,
805: OKC_STATUSES_V status,
806: OKC_STATUSES_B status1,
807: okc_k_headers_b chr,
808: okc_subclasses_b scs
809: WHERE line.STS_CODE = status.CODE

Line 844: OKC_STATUSES_V status,

840: status.CODE,
841: status.STE_CODE,
842: status.meaning
843: FROM OKC_K_LINES_B line,
844: OKC_STATUSES_V status,
845: OKC_STATUSES_B status1,
846: okc_k_headers_b chr,
847: okc_subclasses_b scs
848: WHERE line.STS_CODE = status.CODE

Line 879: OKC_STATUSES_V status,

875: status.CODE,
876: status.STE_CODE,
877: status.meaning
878: FROM OKC_K_LINES_B line,
879: OKC_STATUSES_V status,
880: OKC_STATUSES_B status1,
881: okc_k_headers_b chr,
882: okc_subclasses_b scs
883: WHERE line.STS_CODE = status.CODE

Line 917: OKC_STATUSES_V status,

913: status.CODE,
914: status.STE_CODE,
915: status.meaning
916: FROM OKC_K_LINES_B line,
917: OKC_STATUSES_V status,
918: OKC_STATUSES_B status1,
919: okc_k_headers_b chr,
920: okc_subclasses_b scs
921: WHERE line.STS_CODE = status.CODE

Line 956: OKC_STATUSES_V status,

952: status.CODE,
953: status.STE_CODE,
954: status.meaning
955: FROM OKC_K_LINES_B line,
956: OKC_STATUSES_V status,
957: OKC_STATUSES_B status1,
958: okc_k_headers_b chr,
959: okc_subclasses_b scs
960: WHERE line.STS_CODE = status.CODE

Line 991: OKC_STATUSES_V status,

987: status.CODE,
988: status.STE_CODE,
989: status.meaning
990: FROM OKC_K_LINES_B line,
991: OKC_STATUSES_V status,
992: OKC_STATUSES_B status1,
993: okc_k_headers_b chr,
994: okc_subclasses_b scs
995: WHERE line.STS_CODE = status.CODE

Line 1024: OKC_STATUSES_V status,

1020: status.CODE,
1021: status.STE_CODE,
1022: status.meaning
1023: FROM OKC_K_LINES_B line,
1024: OKC_STATUSES_V status,
1025: fnd_lookups fnd
1026: WHERE line.STS_CODE = status.CODE
1027: AND line.dnz_chr_id = p_kid
1028: --BUG 4915692 --

Line 1052: OKC_STATUSES_V status

1048: status.CODE,
1049: status.STE_CODE,
1050: status.meaning
1051: FROM OKC_K_LINES_B line,
1052: OKC_STATUSES_V status
1053: WHERE line.STS_CODE = status.CODE
1054: AND line.dnz_chr_id = p_kid
1055: --BUG 4915692 --
1056: --AND STATUS.STE_CODE IN ('ACTIVE','HOLD','SIGNED')

Line 1084: OKC_STATUSES_V status

1080: status.CODE,
1081: status.STE_CODE,
1082: status.meaning
1083: FROM OKC_K_LINES_B line,
1084: OKC_STATUSES_V status
1085: WHERE line.STS_CODE = status.CODE
1086: AND line.dnz_chr_id = p_kid
1087: AND status.ste_code = 'SIGNED'
1088: AND line.start_date >= trunc(l_last_rundate) AND

Line 1109: OKC_STATUSES_V status

1105: status.CODE,
1106: status.STE_CODE,
1107: status.meaning
1108: FROM OKC_K_LINES_B line,
1109: OKC_STATUSES_V status
1110: WHERE line.STS_CODE = status.CODE
1111: AND line.dnz_chr_id = p_kid
1112: AND status.ste_code = 'ACTIVE'
1113: AND line.start_date >= trunc(l_last_rundate) AND

Line 3108: OKC_STATUSES_V status,

3104: status.CODE,
3105: status.STE_CODE,
3106: status.meaning
3107: FROM OKC_K_HEADERS_B hdr,
3108: OKC_STATUSES_V status,
3109: OKC_SUBCLASSES_B scs
3110: WHERE hdr.STS_CODE = status.CODE
3111: AND scs.code = hdr.scs_code
3112: and scs.cls_code <> 'OKL'

Line 3147: OKC_STATUSES_V status,

3143: status.CODE,
3144: status.STE_CODE,
3145: status.meaning
3146: FROM OKC_K_HEADERS_B hdr,
3147: OKC_STATUSES_V status,
3148: OKC_SUBCLASSES_B scs
3149: WHERE hdr.STS_CODE = status.CODE
3150: AND scs.code = hdr.scs_code
3151: and scs.cls_code <> 'OKL'

Line 3185: OKC_STATUSES_V status,

3181: status.CODE,
3182: status.STE_CODE,
3183: status.meaning
3184: FROM OKC_K_HEADERS_B hdr,
3185: OKC_STATUSES_V status,
3186: OKC_SUBCLASSES_B scs
3187: WHERE hdr.STS_CODE = status.CODE
3188: AND scs.code = hdr.scs_code
3189: and scs.cls_code <> 'OKL'

Line 3221: OKC_STATUSES_V status,

3217: status.CODE,
3218: status.STE_CODE,
3219: status.meaning
3220: FROM OKC_K_HEADERS_B hdr,
3221: OKC_STATUSES_V status,
3222: OKC_SUBCLASSES_B scs
3223: WHERE hdr.STS_CODE = status.CODE
3224: AND scs.code = hdr.scs_code
3225: and scs.cls_code <> 'OKL'

Line 3255: OKC_STATUSES_V status,

3251: status.CODE,
3252: status.STE_CODE,
3253: status.meaning
3254: FROM OKC_K_HEADERS_B hdr,
3255: OKC_STATUSES_V status,
3256: OKC_SUBCLASSES_B scs
3257: WHERE hdr.STS_CODE = status.CODE
3258: AND scs.code = hdr.scs_code
3259: and scs.cls_code <> 'OKL'

Line 3289: OKC_STATUSES_V status,

3285: status.CODE,
3286: status.STE_CODE,
3287: status.meaning
3288: FROM OKC_K_HEADERS_B hdr,
3289: OKC_STATUSES_V status,
3290: OKC_SUBCLASSES_B scs
3291: WHERE hdr.STS_CODE = status.CODE
3292: AND scs.code = hdr.scs_code
3293: and scs.cls_code <> 'OKL'

Line 3330: OKC_STATUSES_V status,

3326: status.CODE,
3327: status.STE_CODE,
3328: status.meaning
3329: FROM OKC_K_HEADERS_B hdr,
3330: OKC_STATUSES_V status,
3331: OKC_SUBCLASSES_B scs
3332: WHERE hdr.STS_CODE = status.CODE
3333: AND scs.code = hdr.scs_code
3334: and scs.cls_code <> 'OKL'

Line 3369: OKC_STATUSES_V status,

3365: status.CODE,
3366: status.STE_CODE,
3367: status.meaning
3368: FROM OKC_K_HEADERS_B hdr,
3369: OKC_STATUSES_V status,
3370: OKC_SUBCLASSES_B scs
3371: WHERE hdr.STS_CODE = status.CODE
3372: AND scs.code = hdr.scs_code
3373: and scs.cls_code <> 'OKL'

Line 3405: OKC_STATUSES_V status,

3401: status.CODE,
3402: status.STE_CODE,
3403: status.meaning
3404: FROM OKC_K_HEADERS_B hdr,
3405: OKC_STATUSES_V status,
3406: OKC_SUBCLASSES_B scs
3407: WHERE hdr.STS_CODE = status.CODE
3408: AND scs.code = hdr.scs_code
3409: and scs.cls_code <> 'OKL'

Line 3440: OKC_STATUSES_V status,

3436: status.CODE,
3437: status.STE_CODE,
3438: status.meaning
3439: FROM OKC_K_HEADERS_B hdr,
3440: OKC_STATUSES_V status,
3441: OKC_SUBCLASSES_B scs
3442: WHERE hdr.STS_CODE = status.CODE
3443: AND scs.code = hdr.scs_code
3444: and scs.cls_code <> 'OKL'

Line 3475: OKC_STATUSES_V status,

3471: status.CODE,
3472: status.STE_CODE,
3473: status.meaning
3474: FROM OKC_K_HEADERS_B hdr,
3475: OKC_STATUSES_V status,
3476: OKC_SUBCLASSES_B scs
3477: WHERE hdr.STS_CODE = status.CODE
3478: AND scs.code = hdr.scs_code
3479: and scs.cls_code <> 'OKL'

Line 3522: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs

3518: scs.CLS_CODE,
3519: status.CODE,
3520: status.STE_CODE,
3521: status.meaning
3522: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs
3523: WHERE hdr.STS_CODE = status.CODE
3524: AND scs.code = hdr.scs_code
3525: AND scs.cls_code <> 'OKL'
3526: AND ((p_category IS NULL) OR (scs.CODE = p_category))

Line 3564: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs

3560: scs.CLS_CODE,
3561: status.CODE,
3562: status.STE_CODE,
3563: status.meaning
3564: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs
3565: WHERE hdr.STS_CODE = status.CODE
3566: AND scs.code = hdr.scs_code
3567: AND scs.cls_code <> 'OKL'
3568: AND hdr.CONTRACT_NUMBER >= p_from_k

Line 3602: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs

3598: scs.CLS_CODE,
3599: status.CODE,
3600: status.STE_CODE,
3601: status.meaning
3602: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs
3603: WHERE hdr.STS_CODE = status.CODE
3604: AND scs.code = hdr.scs_code
3605: AND scs.cls_code <> 'OKL'
3606: AND scs.CODE = p_category

Line 3639: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs

3635: scs.CLS_CODE,
3636: status.CODE,
3637: status.STE_CODE,
3638: status.meaning
3639: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs
3640: WHERE hdr.STS_CODE = status.CODE
3641: AND scs.code = hdr.scs_code
3642: AND scs.cls_code <> 'OKL'
3643: AND hdr.STS_CODE <> 'QA_HOLD'

Line 3675: OKC_STATUSES_V status,

3671: status.CODE,
3672: status.STE_CODE,
3673: status.meaning
3674: FROM OKC_K_HEADERS_B hdr,
3675: OKC_STATUSES_V status,
3676: FND_LOOKUPS fnd,
3677: OKC_SUBCLASSES_B scs
3678: WHERE hdr.STS_CODE = status.CODE
3679: AND scs.code = hdr.scs_code

Line 3720: OKC_STATUSES_V status,

3716: status.CODE,
3717: status.STE_CODE,
3718: status.meaning
3719: FROM OKC_K_HEADERS_B hdr,
3720: OKC_STATUSES_V status,
3721: FND_LOOKUPS fnd,
3722: OKC_SUBCLASSES_B scs
3723: WHERE hdr.STS_CODE = status.CODE
3724: AND scs.code = hdr.scs_code

Line 3763: OKC_STATUSES_V status,

3759: status.CODE,
3760: status.STE_CODE,
3761: status.meaning
3762: FROM OKC_K_HEADERS_B hdr,
3763: OKC_STATUSES_V status,
3764: FND_LOOKUPS fnd,
3765: OKC_SUBCLASSES_B scs
3766: WHERE hdr.STS_CODE = status.CODE
3767: AND scs.code = hdr.scs_code

Line 3804: OKC_STATUSES_V status,

3800: status.CODE,
3801: status.STE_CODE,
3802: status.meaning
3803: FROM OKC_K_HEADERS_B hdr,
3804: OKC_STATUSES_V status,
3805: FND_LOOKUPS fnd,
3806: OKC_SUBCLASSES_B scs
3807: WHERE hdr.STS_CODE = status.CODE
3808: AND scs.code = hdr.scs_code

Line 3843: OKC_STATUSES_V status,

3839: status.CODE,
3840: status.STE_CODE,
3841: status.meaning
3842: FROM OKC_K_HEADERS_B hdr,
3843: OKC_STATUSES_V status,
3844: FND_LOOKUPS fnd,
3845: OKC_SUBCLASSES_B scs
3846: WHERE hdr.STS_CODE = status.CODE
3847: AND scs.code = hdr.scs_code