eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LOT_SPLIT_DATA_INSERT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 15: item_description MTL_SYSTEM_ITEMS_KFV.description%TYPE,

11: transaction_quantity MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
12: secondary_transaction_quantity MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE, -- Bug #4093379 INVCONV
13: primary_quantity MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
14: transaction_uom MTL_UNITS_OF_MEASURE.uom_code%TYPE,
15: item_description MTL_SYSTEM_ITEMS_KFV.description%TYPE,
16: item_location_control_code MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
17: item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,

Line 16: item_location_control_code MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,

12: secondary_transaction_quantity MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE, -- Bug #4093379 INVCONV
13: primary_quantity MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
14: transaction_uom MTL_UNITS_OF_MEASURE.uom_code%TYPE,
15: item_description MTL_SYSTEM_ITEMS_KFV.description%TYPE,
16: item_location_control_code MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
17: item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,

Line 17: item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,

13: primary_quantity MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
14: transaction_uom MTL_UNITS_OF_MEASURE.uom_code%TYPE,
15: item_description MTL_SYSTEM_ITEMS_KFV.description%TYPE,
16: item_location_control_code MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
17: item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV

Line 18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,

14: transaction_uom MTL_UNITS_OF_MEASURE.uom_code%TYPE,
15: item_description MTL_SYSTEM_ITEMS_KFV.description%TYPE,
16: item_location_control_code MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
17: item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,

Line 19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,

15: item_description MTL_SYSTEM_ITEMS_KFV.description%TYPE,
16: item_location_control_code MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
17: item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,

Line 20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,

16: item_location_control_code MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
17: item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,

Line 21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV

17: item_restrict_subinv_code MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,

Line 22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,

18: item_restrict_locators_code MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV

Line 23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,

19: item_revision_qty_control_code MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV

Line 24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,

20: item_primary_uom_code MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,

Line 142: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,

138: p_locator_id IN MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
139: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
140: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
141: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
142: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
143: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
144: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,

Line 143: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,

139: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
140: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
141: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
142: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
143: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
144: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,

Line 144: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,

140: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
141: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
142: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
143: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
144: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,

Line 145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,

141: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
142: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
143: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
144: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,

Line 146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,

142: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
143: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
144: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,

Line 147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,

143: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
144: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,

Line 148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,

144: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,

Line 149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,

145: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
153: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,

Line 150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,

146: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
153: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
154: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,

Line 233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
236: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
237: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV