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 374: TERMINATION_REASON fnd_lookups.meaning%TYPE,

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

Line 444: fnd_lookups fnd,

440: status.STE_CODE,
441: status.meaning
442: FROM OKC_K_LINES_B line,
443: OKC_STATUSES_V status,
444: fnd_lookups fnd,
445: okc_k_headers_b chr,
446: okc_subclasses_b scs
447: WHERE line.STS_CODE = status.CODE
448: AND line.dnz_chr_id = chr.id

Line 477: FND_LOOKUPS FND,

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

Line 512: FND_LOOKUPS FND,

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

Line 543: FND_LOOKUPS FND,

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

Line 1025: fnd_lookups fnd

1021: status.STE_CODE,
1022: status.meaning
1023: FROM OKC_K_LINES_B line,
1024: OKC_STATUSES_V status,
1025: fnd_lookups fnd
1026: WHERE line.STS_CODE = status.CODE
1027: AND line.dnz_chr_id = p_kid
1028: --BUG 4915692 --
1029: --AND STATUS.STE_CODE IN ('ACTIVE','HOLD','SIGNED')

Line 3676: FND_LOOKUPS fnd,

3672: status.STE_CODE,
3673: status.meaning
3674: FROM OKC_K_HEADERS_B hdr,
3675: OKC_STATUSES_V status,
3676: FND_LOOKUPS fnd,
3677: OKC_SUBCLASSES_B scs
3678: WHERE hdr.STS_CODE = status.CODE
3679: AND scs.code = hdr.scs_code
3680: and scs.cls_code <> 'OKL'

Line 3721: FND_LOOKUPS fnd,

3717: status.STE_CODE,
3718: status.meaning
3719: FROM OKC_K_HEADERS_B hdr,
3720: OKC_STATUSES_V status,
3721: FND_LOOKUPS fnd,
3722: OKC_SUBCLASSES_B scs
3723: WHERE hdr.STS_CODE = status.CODE
3724: AND scs.code = hdr.scs_code
3725: AND scs.cls_code <> 'OKL'

Line 3764: FND_LOOKUPS fnd,

3760: status.STE_CODE,
3761: status.meaning
3762: FROM OKC_K_HEADERS_B hdr,
3763: OKC_STATUSES_V status,
3764: FND_LOOKUPS fnd,
3765: OKC_SUBCLASSES_B scs
3766: WHERE hdr.STS_CODE = status.CODE
3767: AND scs.code = hdr.scs_code
3768: AND scs.cls_code <> 'OKL'

Line 3805: FND_LOOKUPS fnd,

3801: status.STE_CODE,
3802: status.meaning
3803: FROM OKC_K_HEADERS_B hdr,
3804: OKC_STATUSES_V status,
3805: FND_LOOKUPS fnd,
3806: OKC_SUBCLASSES_B scs
3807: WHERE hdr.STS_CODE = status.CODE
3808: AND scs.code = hdr.scs_code
3809: AND scs.cls_code <> 'OKL'

Line 3844: FND_LOOKUPS fnd,

3840: status.STE_CODE,
3841: status.meaning
3842: FROM OKC_K_HEADERS_B hdr,
3843: OKC_STATUSES_V status,
3844: FND_LOOKUPS fnd,
3845: OKC_SUBCLASSES_B scs
3846: WHERE hdr.STS_CODE = status.CODE
3847: AND scs.code = hdr.scs_code
3848: AND scs.cls_code <> 'OKL'