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 853: l_code okl_asset_returns_v.ars_code%type;

849: funcmode IN VARCHAR2,
850: resultout OUT NOCOPY VARCHAR2 )IS
851:
852: l_art_id NUMBER;
853: l_code okl_asset_returns_v.ars_code%type;
854:
855: -- Check that the asset return refers to a Repossession Request
856: CURSOR okl_check_req_csr(c_art_id NUMBER)
857: IS

Line 859: FROM OKL_ASSET_RETURNS_V

855: -- Check that the asset return refers to a Repossession Request
856: CURSOR okl_check_req_csr(c_art_id NUMBER)
857: IS
858: SELECT ARS_CODE
859: FROM OKL_ASSET_RETURNS_V
860: WHERE ID= c_art_id
861: AND ARS_CODE IN ('REPOSSESSED', 'UNSUCCESS_REPO')
862: AND ART1_CODE = 'REPOS_REQUEST';
863:

Line 945: FROM OKL_ASSET_RETURNS_V

941: -- Check that the asset return refers to a Repossession Request
942: CURSOR okl_check_req_csr(c_art_id NUMBER)
943: IS
944: SELECT count(*)
945: FROM OKL_ASSET_RETURNS_V
946: WHERE ID= c_art_id
947: AND ART1_CODE = 'REPOS_REQUEST';
948:
949: BEGIN

Line 1095: l_code okl_asset_returns_v.ars_code%type;

1091: funcmode IN VARCHAR2,
1092: resultout OUT NOCOPY VARCHAR2 )IS
1093:
1094: l_art_id NUMBER;
1095: l_code okl_asset_returns_v.ars_code%type;
1096:
1097: -- Check that the asset return refers to a Repossession Request
1098: CURSOR okl_check_req_csr(c_art_id NUMBER)
1099: IS

Line 1915: FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR

1911: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
1912: AD.SERIAL_NUMBER SERIAL_NUMBER,
1913: AD.MODEL_NUMBER MODEL_NUMBER,
1914: OAR.COMMENTS COMMENTS
1915: FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR
1916: WHERE AD.ID = OAR.KLE_ID
1917: AND OAR.ID = c_art_id;
1918: */
1919: SELECT OAR.LAST_UPDATED_BY LAST_UPDATED_BY,

Line 1929: OKL_ASSET_RETURNS_V OAR,

1925: OAR.COMMENTS COMMENTS,
1926: C.CONTACT_PARTY_NAME CONTACT_NAME,
1927: CP.CONTACT_DETAILS CONTACT_DETAILS
1928: FROM OKL_AM_ASSET_DETAILS_UV AD,
1929: OKL_ASSET_RETURNS_V OAR,
1930: OKL_RELOCATE_ASSETS_V ORA,
1931: OKL_AM_CONTACT_POINTS_UV CP,
1932: OKL_AM_CONTACTS_UV C
1933: WHERE AD.ID = OAR.KLE_ID

Line 2641: FROM OKL_ASSET_RETURNS_V

2637: -- cursor to check request is valid
2638: CURSOR okl_check_req_csr(c_art_id NUMBER)
2639: IS
2640: SELECT last_updated_by
2641: FROM OKL_ASSET_RETURNS_V
2642: WHERE ID= c_art_id;
2643:
2644: BEGIN
2645: