APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_ASSET_RETURNS_V

Line 26: FROM OKL_ASSET_RETURNS_V

22: -- cursor to check request is valid
23: CURSOR okl_check_req_csr(c_art_id NUMBER)
24: IS
25: SELECT count(*)
26: FROM OKL_ASSET_RETURNS_V
27: WHERE ID= c_art_id;
28:
29: BEGIN
30:

Line 102: FROM OKL_ASSET_RETURNS_V OARV,

98: -- cursor to check request is valid
99: CURSOR okl_check_req_csr(c_art_id NUMBER)
100: IS
101: SELECT count(*)
102: FROM OKL_ASSET_RETURNS_V OARV,
103: OKL_AM_REMARKET_TEAMS_UV ORTU
104: WHERE OARV.ID= c_art_id
105: AND OARV.RMR_ID = ORTU.ORIG_SYSTEM_ID;
106:

Line 189: OKL_ASSET_RETURNS_V OAR

185: OAR.DATE_REPOSSESSION_ACTUAL DATE_RETURNED, AD.ID KLE_ID,
186: OAR.COMMENTS COMMENTS
187: FROM
188: OKL_AM_ASSET_DETAILS_UV AD,
189: OKL_ASSET_RETURNS_V OAR
190: WHERE
191: AD.ID = OAR.KLE_ID
192: AND oar.id = c_art_id; */
193: SELECT

Line 208: OKL_ASSET_RETURNS_V OAR

204: OAR.COMMENTS COMMENTS
205: FROM OKC_K_LINES_V CLEV
206: ,OKX_ASSET_LINES_V OALV
207: ,OKC_K_HEADERS_ALL_B OKHV ,
208: OKL_ASSET_RETURNS_V OAR
209: WHERE CLEV.ID = OAR.KLE_ID
210: AND CLEV.ID = OALV.PARENT_LINE_ID(+)
211: AND CLEV.CHR_ID = OKHV.ID
212: AND CLEV.STS_CODE <> 'ABANDONED'

Line 563: FROM OKL_ASSET_RETURNS_V OAR

559: OAR.DATE_REPOSSESSION_ACTUAL DATE_RETURNED,
560: OAR.RMR_ID RMR_ID,
561: OAR.COMMENTS COMMENTS,
562: OAR.KLE_ID KLE_ID
563: FROM OKL_ASSET_RETURNS_V OAR
564: WHERE OAR.ID = c_art_id;
565:
566: CURSOR okl_asset_details_csr(c_kle_id NUMBER)
567: IS

Line 898: l_code okl_asset_returns_v.ars_code%type;

894: funcmode IN VARCHAR2,
895: resultout OUT NOCOPY VARCHAR2 )IS
896:
897: l_art_id NUMBER;
898: l_code okl_asset_returns_v.ars_code%type;
899:
900: -- Check that the asset return refers to a Repossession Request
901: CURSOR okl_check_req_csr(c_art_id NUMBER)
902: IS

Line 904: FROM OKL_ASSET_RETURNS_V

900: -- Check that the asset return refers to a Repossession Request
901: CURSOR okl_check_req_csr(c_art_id NUMBER)
902: IS
903: SELECT ARS_CODE
904: FROM OKL_ASSET_RETURNS_V
905: WHERE ID= c_art_id
906: AND ARS_CODE IN ('REPOSSESSED', 'UNSUCCESS_REPO')
907: AND ART1_CODE = 'REPOS_REQUEST';
908:

Line 990: FROM OKL_ASSET_RETURNS_V

986: -- Check that the asset return refers to a Repossession Request
987: CURSOR okl_check_req_csr(c_art_id NUMBER)
988: IS
989: SELECT count(*)
990: FROM OKL_ASSET_RETURNS_V
991: WHERE ID= c_art_id
992: AND ART1_CODE = 'REPOS_REQUEST';
993:
994: BEGIN

Line 1140: l_code okl_asset_returns_v.ars_code%type;

1136: funcmode IN VARCHAR2,
1137: resultout OUT NOCOPY VARCHAR2 )IS
1138:
1139: l_art_id NUMBER;
1140: l_code okl_asset_returns_v.ars_code%type;
1141:
1142: -- Check that the asset return refers to a Repossession Request
1143: CURSOR okl_check_req_csr(c_art_id NUMBER)
1144: IS

Line 1972: FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR

1968: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
1969: AD.SERIAL_NUMBER SERIAL_NUMBER,
1970: AD.MODEL_NUMBER MODEL_NUMBER,
1971: OAR.COMMENTS COMMENTS
1972: FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR
1973: WHERE AD.ID = OAR.KLE_ID
1974: AND OAR.ID = c_art_id;
1975: */
1976: SELECT OAR.LAST_UPDATED_BY LAST_UPDATED_BY,

Line 1986: OKL_ASSET_RETURNS_V OAR,

1982: OAR.COMMENTS COMMENTS,
1983: C.CONTACT_PARTY_NAME CONTACT_NAME,
1984: CP.CONTACT_DETAILS CONTACT_DETAILS
1985: FROM OKL_AM_ASSET_DETAILS_UV AD,
1986: OKL_ASSET_RETURNS_V OAR,
1987: OKL_RELOCATE_ASSETS_V ORA,
1988: OKL_AM_CONTACT_POINTS_UV CP,
1989: OKL_AM_CONTACTS_UV C
1990: WHERE AD.ID = OAR.KLE_ID

Line 2698: FROM OKL_ASSET_RETURNS_V

2694: -- cursor to check request is valid
2695: CURSOR okl_check_req_csr(c_art_id NUMBER)
2696: IS
2697: SELECT last_updated_by
2698: FROM OKL_ASSET_RETURNS_V
2699: WHERE ID= c_art_id;
2700:
2701: BEGIN
2702: