[Home] [Help]
471: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
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
506: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
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
537: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
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
625: stsb.CODE,
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
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
681: WHERE line.STS_CODE = stst.CODE
715: stsb.CODE,
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