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.OKL_TBC_PVT dependencies on FND_LOOKUP_VALUES

Line 703: FROM Fnd_Lookup_Values

699: l_dummy_var VARCHAR2(1) := '?' ;
700:
701: CURSOR okl_tbcv_prch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
702: SELECT 'x'
703: FROM Fnd_Lookup_Values
704: WHERE fnd_lookup_values.lookup_code = p_lookup_code
705: AND fnd_lookup_values.lookup_type = p_lookup_type;
706:
707: BEGIN

Line 704: WHERE fnd_lookup_values.lookup_code = p_lookup_code

700:
701: CURSOR okl_tbcv_prch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
702: SELECT 'x'
703: FROM Fnd_Lookup_Values
704: WHERE fnd_lookup_values.lookup_code = p_lookup_code
705: AND fnd_lookup_values.lookup_type = p_lookup_type;
706:
707: BEGIN
708:

Line 705: AND fnd_lookup_values.lookup_type = p_lookup_type;

701: CURSOR okl_tbcv_prch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
702: SELECT 'x'
703: FROM Fnd_Lookup_Values
704: WHERE fnd_lookup_values.lookup_code = p_lookup_code
705: AND fnd_lookup_values.lookup_type = p_lookup_type;
706:
707: BEGIN
708:
709: IF (p_tbcv_rec.purchase_option_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.purchase_option_code IS NOT NULL)

Line 728: 'FND_LOOKUP_VALUES');

724: 'purchase_option_code',
725: g_child_table_token ,
726: 'OKL_TAX_ATTR_DEFINITIONS',
727: g_parent_table_token ,
728: 'FND_LOOKUP_VALUES');
729: l_return_status := OKC_API.G_RET_STS_ERROR;
730:
731: END IF;
732: END IF;

Line 915: FROM Fnd_Lookup_Values

911: l_dummy_var VARCHAR2(1) := '?' ;
912:
913: CURSOR okl_tbcv_int_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
914: SELECT 'x'
915: FROM Fnd_Lookup_Values
916: WHERE fnd_lookup_values.lookup_code = p_lookup_code
917: AND fnd_lookup_values.lookup_type = p_lookup_type;
918: BEGIN
919:

Line 916: WHERE fnd_lookup_values.lookup_code = p_lookup_code

912:
913: CURSOR okl_tbcv_int_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
914: SELECT 'x'
915: FROM Fnd_Lookup_Values
916: WHERE fnd_lookup_values.lookup_code = p_lookup_code
917: AND fnd_lookup_values.lookup_type = p_lookup_type;
918: BEGIN
919:
920: IF (p_tbcv_rec.int_disclosed_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.int_disclosed_code IS NOT NULL)

Line 917: AND fnd_lookup_values.lookup_type = p_lookup_type;

913: CURSOR okl_tbcv_int_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
914: SELECT 'x'
915: FROM Fnd_Lookup_Values
916: WHERE fnd_lookup_values.lookup_code = p_lookup_code
917: AND fnd_lookup_values.lookup_type = p_lookup_type;
918: BEGIN
919:
920: IF (p_tbcv_rec.int_disclosed_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.int_disclosed_code IS NOT NULL)
921: THEN

Line 938: 'FND_LOOKUP_VALUES');

934: 'int_disclosed_code',
935: g_child_table_token ,
936: 'OKL_TAX_ATTR_DEFINITIONS',
937: g_parent_table_token ,
938: 'FND_LOOKUP_VALUES');
939: l_return_status := OKC_API.G_RET_STS_ERROR;
940:
941: END IF;
942: END IF;

Line 968: FROM Fnd_Lookup_Values

964: l_dummy_var VARCHAR2(1) := '?' ;
965:
966: CURSOR okl_tbcv_title_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
967: SELECT 'x'
968: FROM Fnd_Lookup_Values
969: WHERE fnd_lookup_values.lookup_code = p_lookup_code
970: AND fnd_lookup_values.lookup_type = p_lookup_type;
971: BEGIN
972:

Line 969: WHERE fnd_lookup_values.lookup_code = p_lookup_code

965:
966: CURSOR okl_tbcv_title_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
967: SELECT 'x'
968: FROM Fnd_Lookup_Values
969: WHERE fnd_lookup_values.lookup_code = p_lookup_code
970: AND fnd_lookup_values.lookup_type = p_lookup_type;
971: BEGIN
972:
973: IF (p_tbcv_rec.title_trnsfr_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.title_trnsfr_code IS NOT NULL)

Line 970: AND fnd_lookup_values.lookup_type = p_lookup_type;

966: CURSOR okl_tbcv_title_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
967: SELECT 'x'
968: FROM Fnd_Lookup_Values
969: WHERE fnd_lookup_values.lookup_code = p_lookup_code
970: AND fnd_lookup_values.lookup_type = p_lookup_type;
971: BEGIN
972:
973: IF (p_tbcv_rec.title_trnsfr_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.title_trnsfr_code IS NOT NULL)
974: THEN

Line 987: 'FND_LOOKUP_VALUES');

983: 'title_trnsfr_code',
984: g_child_table_token ,
985: 'OKL_TAX_ATTR_DEFINITIONS',
986: g_parent_table_token ,
987: 'FND_LOOKUP_VALUES');
988: l_return_status := OKC_API.G_RET_STS_ERROR;
989:
990: END IF;
991: END IF;

Line 1016: FROM Fnd_Lookup_Values

1012: l_dummy_var VARCHAR2(1) := '?' ;
1013:
1014: CURSOR okl_tbcv_salelease_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1015: SELECT 'x'
1016: FROM Fnd_Lookup_Values
1017: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1018: AND fnd_lookup_values.lookup_type = p_lookup_type;
1019: BEGIN
1020:

Line 1017: WHERE fnd_lookup_values.lookup_code = p_lookup_code

1013:
1014: CURSOR okl_tbcv_salelease_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1015: SELECT 'x'
1016: FROM Fnd_Lookup_Values
1017: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1018: AND fnd_lookup_values.lookup_type = p_lookup_type;
1019: BEGIN
1020:
1021: IF (p_tbcv_rec.sale_lease_back_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.sale_lease_back_code IS NOT NULL)

Line 1018: AND fnd_lookup_values.lookup_type = p_lookup_type;

1014: CURSOR okl_tbcv_salelease_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1015: SELECT 'x'
1016: FROM Fnd_Lookup_Values
1017: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1018: AND fnd_lookup_values.lookup_type = p_lookup_type;
1019: BEGIN
1020:
1021: IF (p_tbcv_rec.sale_lease_back_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.sale_lease_back_code IS NOT NULL)
1022: THEN

Line 1039: 'FND_LOOKUP_VALUES');

1035: 'sale_lease_back_code',
1036: g_child_table_token ,
1037: 'OKL_TAX_ATTR_DEFINITIONS',
1038: g_parent_table_token ,
1039: 'FND_LOOKUP_VALUES');
1040: l_return_status := OKC_API.G_RET_STS_ERROR;
1041: END IF;
1042: END IF;
1043: x_return_status := l_return_status;

Line 1067: FROM Fnd_Lookup_Values

1063: l_dummy_var VARCHAR2(1) := '?' ;
1064:
1065: CURSOR okl_tbcv_saleprch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1066: SELECT 'x'
1067: FROM Fnd_Lookup_Values
1068: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1069: AND fnd_lookup_values.lookup_type = p_lookup_type;
1070: BEGIN
1071:

Line 1068: WHERE fnd_lookup_values.lookup_code = p_lookup_code

1064:
1065: CURSOR okl_tbcv_saleprch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1066: SELECT 'x'
1067: FROM Fnd_Lookup_Values
1068: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1069: AND fnd_lookup_values.lookup_type = p_lookup_type;
1070: BEGIN
1071:
1072: IF (p_tbcv_rec.lease_purchased_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.lease_purchased_code IS NOT NULL)

Line 1069: AND fnd_lookup_values.lookup_type = p_lookup_type;

1065: CURSOR okl_tbcv_saleprch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1066: SELECT 'x'
1067: FROM Fnd_Lookup_Values
1068: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1069: AND fnd_lookup_values.lookup_type = p_lookup_type;
1070: BEGIN
1071:
1072: IF (p_tbcv_rec.lease_purchased_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.lease_purchased_code IS NOT NULL)
1073: THEN

Line 1090: 'FND_LOOKUP_VALUES');

1086: 'lease_purchased_code',
1087: g_child_table_token ,
1088: 'OKL_TAX_ATTR_DEFINITIONS',
1089: g_parent_table_token ,
1090: 'FND_LOOKUP_VALUES');
1091: l_return_status := OKC_API.G_RET_STS_ERROR;
1092: END IF;
1093: END IF;
1094: x_return_status := l_return_status;