DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 19: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,

15: p_locator_id IN MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
16: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
17: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
18: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
19: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,

Line 20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,

16: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
17: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
18: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
19: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,

Line 21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,

17: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
18: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
19: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,

Line 22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,

18: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
19: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,

Line 23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,

19: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,

Line 24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,

20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
28: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,

Line 25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,

21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,
22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
28: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
29: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,

Line 26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,

22: p_item_restrict_locators_code IN MTL_SYSTEM_ITEMS_KFV.restrict_locators_code%TYPE,
23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
28: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
29: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
30: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,

Line 27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,

23: p_item_revision_qty_control_cd IN MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE,
24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
28: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
29: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
30: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
31: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,

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

106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
114: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV