DBA Data[Home] [Help]

APPS.OKL_REBOOK_CM_PVT dependencies on OKX_CUST_TRX_TYPES_V

Line 34: FROM OKX_CUST_TRX_TYPES_V

30:
31: -- Replace with following query
32: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
33: SELECT ID1
34: FROM OKX_CUST_TRX_TYPES_V
35: WHERE name = 'Invoice-OKL' AND
36: set_of_books_id = p_sob_id AND
37: org_id = p_org_id;
38:

Line 247: FROM OKX_CUST_TRX_TYPES_V

243: -- Get trx_id for Invoice
244: ------------------------------------------------------------
245: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
246: SELECT ID1
247: FROM OKX_CUST_TRX_TYPES_V
248: WHERE name = 'Invoice-OKL' AND
249: set_of_books_id = p_sob_id AND
250: org_id = p_org_id;
251:

Line 259: FROM OKX_CUST_TRX_TYPES_V

255: -- Get trx_id for Credit Memo
256: ------------------------------------------------------------
257: CURSOR c_trx_id1( p_sob_id NUMBER, p_org_id NUMBER ) IS
258: SELECT ID1
259: FROM OKX_CUST_TRX_TYPES_V
260: WHERE name = 'Credit Memo-OKL' AND
261: set_of_books_id = p_sob_id AND
262: org_id = p_org_id; */
263:

Line 1804: FROM OKX_CUST_TRX_TYPES_V

1800: -- Get trx_id for Invoice
1801: ------------------------------------------------------------
1802: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
1803: SELECT ID1
1804: FROM OKX_CUST_TRX_TYPES_V
1805: WHERE name = 'Invoice-OKL' AND
1806: set_of_books_id = p_sob_id AND
1807: org_id = p_org_id;
1808:

Line 1816: FROM OKX_CUST_TRX_TYPES_V

1812: -- Get trx_id for Credit Memo
1813: ------------------------------------------------------------
1814: CURSOR c_trx_id1( p_sob_id NUMBER, p_org_id NUMBER ) IS
1815: SELECT ID1
1816: FROM OKX_CUST_TRX_TYPES_V
1817: WHERE name = 'Credit Memo-OKL' AND
1818: set_of_books_id = p_sob_id AND
1819: org_id = p_org_id; */
1820: