DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_SERIAL_NUMBERS

Line 11: TYPE SERIAL_NUMBER_TABLE IS TABLE OF MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE

7: TYPE NUMBER_TABLE IS TABLE of NUMBER;
8: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
9: TYPE LOT_NUMBER_TABLE IS TABLE of VARCHAR2(80);
10: --Tables added to support Lot Serialized Items in Lot Transactions(Split/Merge/Translate).
11: TYPE SERIAL_NUMBER_TABLE IS TABLE OF MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE
12: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
13: TYPE PARENT_LOT_TABLE IS TABLE OF MTL_LOT_NUMBERS.LOT_NUMBER%TYPE
14: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
15: TYPE PARENT_LOC_TABLE IS TABLE OF MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE

Line 12: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

8: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
9: TYPE LOT_NUMBER_TABLE IS TABLE of VARCHAR2(80);
10: --Tables added to support Lot Serialized Items in Lot Transactions(Split/Merge/Translate).
11: TYPE SERIAL_NUMBER_TABLE IS TABLE OF MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE
12: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
13: TYPE PARENT_LOT_TABLE IS TABLE OF MTL_LOT_NUMBERS.LOT_NUMBER%TYPE
14: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
15: TYPE PARENT_LOC_TABLE IS TABLE OF MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE
16: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

Line 14: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

10: --Tables added to support Lot Serialized Items in Lot Transactions(Split/Merge/Translate).
11: TYPE SERIAL_NUMBER_TABLE IS TABLE OF MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE
12: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
13: TYPE PARENT_LOT_TABLE IS TABLE OF MTL_LOT_NUMBERS.LOT_NUMBER%TYPE
14: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
15: TYPE PARENT_LOC_TABLE IS TABLE OF MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE
16: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
17: TYPE PARENT_SUB_TABLE IS TABLE OF MTL_ITEM_LOCATIONS.SUBINVENTORY_CODE%TYPE
18: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

Line 16: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

12: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
13: TYPE PARENT_LOT_TABLE IS TABLE OF MTL_LOT_NUMBERS.LOT_NUMBER%TYPE
14: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
15: TYPE PARENT_LOC_TABLE IS TABLE OF MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE
16: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
17: TYPE PARENT_SUB_TABLE IS TABLE OF MTL_ITEM_LOCATIONS.SUBINVENTORY_CODE%TYPE
18: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
19:
20:

Line 18: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

14: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
15: TYPE PARENT_LOC_TABLE IS TABLE OF MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE
16: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
17: TYPE PARENT_SUB_TABLE IS TABLE OF MTL_ITEM_LOCATIONS.SUBINVENTORY_CODE%TYPE
18: INDEX BY MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
19:
20:
21: TYPE SUB_CODE_TABLE IS TABLE of Varchar2(30);
22: TYPE REVISION_TABLE IS TABLE of VARCHAR2(10);