DBA Data[Home] [Help]

APPS.INV_STANDALONE_SYNC_PUB dependencies on MTL_ADJUSTMENT_TXN_SYNC_V

Line 6: TYPE adj_txn_tbl_type IS TABLE OF MTL_ADJUSTMENT_TXN_SYNC_V%ROWTYPE INDEX BY BINARY_INTEGER;

2: /* $Header: INVSLSPB.pls 120.1 2010/01/19 09:42:14 hjogleka noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_STANDALONE_SYNC_PUB';
5: g_debug NUMBER;
6: TYPE adj_txn_tbl_type IS TABLE OF MTL_ADJUSTMENT_TXN_SYNC_V%ROWTYPE INDEX BY BINARY_INTEGER;
7: -- Bug 8784314
8: TYPE txn_id_tbl_type IS TABLE OF NUMBER;
9: TYPE t_genref IS REF CURSOR;
10:

Line 387: || ' FROM MTL_ADJUSTMENT_TXN_SYNC_V '

383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385:
386: stmt := 'SELECT * '
387: || ' FROM MTL_ADJUSTMENT_TXN_SYNC_V '
388: || ' WHERE organization_id = :org '
389: || ' AND Category = :category '
390: || ' AND Creation_Date BETWEEN :fr_date AND :to_date ';
391: