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 375: CODE okc_statuses_b.code%TYPE,

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

Line 376: STE_CODE okc_statuses_b.ste_code%TYPE,

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

Line 476: OKC_STATUSES_B stsb,

472: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
473: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
474: FROM OKC_K_LINES_B LINE,
475: OKC_STATUSES_TL stst,
476: OKC_STATUSES_B stsb,
477: FND_LOOKUPS FND,
478: OKC_K_HEADERS_B CHR,
479: OKC_SUBCLASSES_B SCS
480: WHERE LINE.STS_CODE = STST.CODE

Line 511: OKC_STATUSES_B stsb,

507: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
508: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
509: FROM OKC_K_LINES_B LINE,
510: OKC_STATUSES_TL stst,
511: OKC_STATUSES_B stsb,
512: FND_LOOKUPS FND,
513: OKC_K_HEADERS_B CHR,
514: OKC_SUBCLASSES_B SCS
515: WHERE LINE.STS_CODE = STST.CODE

Line 542: OKC_STATUSES_B stsb,

538: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
539: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
540: FROM OKC_K_LINES_B LINE,
541: OKC_STATUSES_TL stst,
542: OKC_STATUSES_B stsb,
543: FND_LOOKUPS FND,
544: OKC_K_HEADERS_B CHR,
545: OKC_SUBCLASSES_B SCS
546: WHERE LINE.STS_CODE = STST.CODE

Line 630: OKC_STATUSES_B stsb,

626: stsb.STE_CODE,
627: stst.meaning
628: FROM OKC_K_LINES_B line,
629: OKC_STATUSES_TL stst,
630: OKC_STATUSES_B stsb,
631: OKC_K_HEADERS_B chr
632: -- okc_subclasses_b scs
633: WHERE line.STS_CODE = stst.CODE
634: AND line.dnz_chr_id = chr.id

Line 678: OKC_STATUSES_B stsb,

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

Line 720: OKC_STATUSES_B stsb,

716: stsb.STE_CODE,
717: stst.meaning
718: FROM OKC_K_LINES_B line,
719: OKC_STATUSES_TL stst,
720: OKC_STATUSES_B stsb,
721: OKC_K_HEADERS_B chr
722: -- okc_subclasses_b scs
723: WHERE line.STS_CODE = stst.CODE
724: AND line.dnz_chr_id = chr.id

Line 762: OKC_STATUSES_B status1,

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

Line 806: OKC_STATUSES_B status1,

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

Line 845: OKC_STATUSES_B status1,

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

Line 880: OKC_STATUSES_B status1,

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

Line 918: OKC_STATUSES_B status1,

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

Line 957: OKC_STATUSES_B status1,

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

Line 992: OKC_STATUSES_B status1,

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