DBA Data[Home] [Help]

APPS.INV_RESERVATION_GLOBAL dependencies on MTL_SYSTEM_ITEMS

Line 43: -- see TRM for table MTL_SYSTEM_ITEMS (column REVISION_QTY_CONTROL_CODE)

39: /*** End R12 ***/
40: --
41: -- Constants for revision control code
42: -- same as MTL_ENG_QUANTITY QuickCode in MFG_LOOKUPS
43: -- see TRM for table MTL_SYSTEM_ITEMS (column REVISION_QTY_CONTROL_CODE)
44: g_revision_control_no CONSTANT NUMBER := 1;
45: g_revision_control_yes CONSTANT NUMBER := 2;
46: --
47: -- Constants for locator control code

Line 49: -- see TRM for table MTL_SYSTEM_ITEMS (column LOCATION_CONTROL_CODE)

45: g_revision_control_yes CONSTANT NUMBER := 2;
46: --
47: -- Constants for locator control code
48: -- same as MTL_LOCATION_CONTROL QuickCode in MFG_LOOKUPS
49: -- see TRM for table MTL_SYSTEM_ITEMS (column LOCATION_CONTROL_CODE)
50: g_locator_control_no CONSTANT NUMBER := 1;
51: g_locator_control_prespecified CONSTANT NUMBER := 2;
52: g_locator_control_dynamic CONSTANT NUMBER := 3;
53: g_locator_control_by_sub CONSTANT NUMBER := 4;

Line 58: -- see TRM for table MTL_SYSTEM_ITEMS (column LOT_CONTROL_CODE)

54: g_locator_control_by_item CONSTANT NUMBER := 5;
55: --
56: -- Constants for lot control code
57: -- same as MTL_LOT_CONTROL QuickCode in MFG_LOOKUPS
58: -- see TRM for table MTL_SYSTEM_ITEMS (column LOT_CONTROL_CODE)
59: g_lot_control_no CONSTANT NUMBER := 1;
60: g_lot_control_yes CONSTANT NUMBER := 2;
61: --
62: -- Constants for serial number control code

Line 64: -- see TRM for table MTL_SYSTEM_ITEMS (column SERIAL_NUMBER_CONTROL_CODE)

60: g_lot_control_yes CONSTANT NUMBER := 2;
61: --
62: -- Constants for serial number control code
63: -- same as MTL_SERIAL_NUMBER QuickCode in MFG_LOOKUPS
64: -- see TRM for table MTL_SYSTEM_ITEMS (column SERIAL_NUMBER_CONTROL_CODE)
65: g_serial_control_no CONSTANT NUMBER := 1;
66: g_serial_control_predefined CONSTANT NUMBER := 2;
67: g_serial_control_dynamic_inv CONSTANT NUMBER := 5;
68: g_serial_control_dynamic_so CONSTANT NUMBER := 6;

Line 151: SUBTYPE item_record IS MTL_SYSTEM_ITEMS%ROWTYPE;

147: , reservable_type NUMBER
148: );
149: --
150: */
151: SUBTYPE item_record IS MTL_SYSTEM_ITEMS%ROWTYPE;
152: SUBTYPE organization_record IS MTL_PARAMETERS%ROWTYPE;
153: SUBTYPE locator_record IS MTL_ITEM_LOCATIONS%ROWTYPE;
154: SUBTYPE sub_record IS MTL_SECONDARY_INVENTORIES%ROWTYPE;
155: SUBTYPE serial_record IS MTL_SERIAL_NUMBERS%ROWTYPE;