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 1819: FROM OKX_CUST_TRX_TYPES_V

1815: -- Get trx_id for Invoice
1816: ------------------------------------------------------------
1817: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
1818: SELECT ID1
1819: FROM OKX_CUST_TRX_TYPES_V
1820: WHERE name = 'Invoice-OKL' AND
1821: set_of_books_id = p_sob_id AND
1822: org_id = p_org_id;
1823:

Line 1831: FROM OKX_CUST_TRX_TYPES_V

1827: -- Get trx_id for Credit Memo
1828: ------------------------------------------------------------
1829: CURSOR c_trx_id1( p_sob_id NUMBER, p_org_id NUMBER ) IS
1830: SELECT ID1
1831: FROM OKX_CUST_TRX_TYPES_V
1832: WHERE name = 'Credit Memo-OKL' AND
1833: set_of_books_id = p_sob_id AND
1834: org_id = p_org_id; */
1835: