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.

APPS.OKC_STATUS_CHANGE_PVT dependencies on OKC_STATUSES_B

Line 361: CODE okc_statuses_b.code%TYPE,

357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%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;

Line 362: STE_CODE okc_statuses_b.ste_code%TYPE,

358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%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;

Line 462: OKC_STATUSES_B stsb,

458: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
459: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
460: FROM OKC_K_LINES_B LINE,
461: OKC_STATUSES_TL stst,
462: OKC_STATUSES_B stsb,
463: FND_LOOKUPS FND,
464: OKC_K_HEADERS_B CHR,
465: OKC_SUBCLASSES_B SCS
466: WHERE LINE.STS_CODE = STST.CODE

Line 495: OKC_STATUSES_B stsb,

491: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
492: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
493: FROM OKC_K_LINES_B LINE,
494: OKC_STATUSES_TL stst,
495: OKC_STATUSES_B stsb,
496: FND_LOOKUPS FND,
497: OKC_K_HEADERS_B CHR,
498: OKC_SUBCLASSES_B SCS
499: WHERE LINE.STS_CODE = STST.CODE

Line 524: OKC_STATUSES_B stsb,

520: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
521: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
522: FROM OKC_K_LINES_B LINE,
523: OKC_STATUSES_TL stst,
524: OKC_STATUSES_B stsb,
525: FND_LOOKUPS FND,
526: OKC_K_HEADERS_B CHR,
527: OKC_SUBCLASSES_B SCS
528: WHERE LINE.STS_CODE = STST.CODE

Line 610: OKC_STATUSES_B stsb,

606: stsb.STE_CODE,
607: stst.meaning
608: FROM OKC_K_LINES_B line,
609: OKC_STATUSES_TL stst,
610: OKC_STATUSES_B stsb,
611: OKC_K_HEADERS_B chr
612: -- okc_subclasses_b scs
613: WHERE line.STS_CODE = stst.CODE
614: AND line.dnz_chr_id = chr.id

Line 658: OKC_STATUSES_B stsb,

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
661: WHERE line.STS_CODE = stst.CODE
662: AND line.dnz_chr_id = chr.id

Line 700: OKC_STATUSES_B stsb,

696: stsb.STE_CODE,
697: stst.meaning
698: FROM OKC_K_LINES_B line,
699: OKC_STATUSES_TL stst,
700: OKC_STATUSES_B stsb,
701: OKC_K_HEADERS_B chr
702: -- okc_subclasses_b scs
703: WHERE line.STS_CODE = stst.CODE
704: AND line.dnz_chr_id = chr.id

Line 742: OKC_STATUSES_B status1,

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
746: AND line.dnz_chr_id = chr.id

Line 786: OKC_STATUSES_B status1,

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
790: AND line.dnz_chr_id = chr.id

Line 825: OKC_STATUSES_B status1,

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
829: AND line.dnz_chr_id = chr.id

Line 860: OKC_STATUSES_B status1,

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
864: AND line.dnz_chr_id = chr.id

Line 898: OKC_STATUSES_B status1,

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
902: AND line.dnz_chr_id = chr.id

Line 937: OKC_STATUSES_B status1,

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
941: AND line.dnz_chr_id = chr.id

Line 972: OKC_STATUSES_B status1,

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
976: AND line.dnz_chr_id = chr.id