[Home] [Help]
457: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
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
490: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
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
519: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
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
605: stsb.CODE,
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
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
661: WHERE line.STS_CODE = stst.CODE
695: stsb.CODE,
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