APPS.OKC_STATUS_CHANGE_PVT dependencies on FND_LOOKUPS

Line 46: v_termination_reason fnd_lookups.meaning%type := NULL ;

42: l_new_status VARCHAR2(30);
43: l_new_status_m VARCHAR2(90);
44: --
45: v_id NUMBER := 0;
46: v_termination_reason fnd_lookups.meaning%type := NULL ;
47:
48: -- Global var holding the User Id
49: user_id NUMBER;
50:

Line 360: TERMINATION_REASON fnd_lookups.meaning%TYPE,

356: END_DATE okc_k_lines_b.end_date%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:

Line 430: fnd_lookups fnd,

426: status.STE_CODE,
427: status.meaning
428: FROM OKC_K_LINES_B line,
429: OKC_STATUSES_V status,
430: fnd_lookups fnd,
431: okc_k_headers_b chr,
432: okc_subclasses_b scs
433: WHERE line.STS_CODE = status.CODE
434: AND line.dnz_chr_id = chr.id

Line 463: FND_LOOKUPS FND,

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
467: AND LINE.DNZ_CHR_ID = CHR.ID

Line 496: FND_LOOKUPS FND,

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
500: AND LINE.DNZ_CHR_ID = CHR.ID

Line 525: FND_LOOKUPS FND,

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
529: AND LINE.DNZ_CHR_ID = CHR.ID

Line 1005: fnd_lookups fnd

1001: status.STE_CODE,
1002: status.meaning
1003: FROM OKC_K_LINES_B line,
1004: OKC_STATUSES_V status,
1005: fnd_lookups fnd
1006: WHERE line.STS_CODE = status.CODE
1007: AND line.dnz_chr_id = p_kid
1008: --BUG 4915692 --
1009: --AND STATUS.STE_CODE IN ('ACTIVE','HOLD','SIGNED')

Line 3210: FND_LOOKUPS fnd,

3206: status.STE_CODE,
3207: status.meaning
3208: FROM OKC_K_HEADERS_B hdr,
3209: OKC_STATUSES_V status,
3210: FND_LOOKUPS fnd,
3211: OKC_SUBCLASSES_B scs
3212: WHERE hdr.STS_CODE = status.CODE
3213: AND scs.code = hdr.scs_code
3214: and scs.cls_code <> 'OKL'