DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 11: transaction_quantity MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,

7: revision MTL_ITEM_REVISIONS.revision%TYPE,
8: organization_id MTL_PARAMETERS.organization_id%TYPE,
9: subinventory_code MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
10: locator_id MTL_ITEM_LOCATIONS.inventory_location_id%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,

Line 12: secondary_transaction_quantity MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE, -- Bug #4093379 INVCONV

8: organization_id MTL_PARAMETERS.organization_id%TYPE,
9: subinventory_code MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
10: locator_id MTL_ITEM_LOCATIONS.inventory_location_id%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,

Line 13: primary_quantity MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,

9: subinventory_code MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
10: locator_id MTL_ITEM_LOCATIONS.inventory_location_id%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,

Line 36: cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.cost_group_id%TYPE,

32: reason_id MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE, -- Bug #4093379 INVCONV
33: lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
34: lpn_number WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
35: xfr_lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
36: cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.cost_group_id%TYPE,
37: project_id NUMBER,
38: task_id NUMBER,
39: transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,
40: transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,

Line 39: transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,

35: xfr_lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
36: cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.cost_group_id%TYPE,
37: project_id NUMBER,
38: task_id NUMBER,
39: transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,
40: transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,
41: transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,
42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,

Line 40: transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,

36: cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.cost_group_id%TYPE,
37: project_id NUMBER,
38: task_id NUMBER,
39: transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,
40: transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,
41: transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,
42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,

Line 41: transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,

37: project_id NUMBER,
38: task_id NUMBER,
39: transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,
40: transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,
41: transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,
42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,

Line 42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,

38: task_id NUMBER,
39: transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,
40: transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,
41: transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,
42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,

Line 139: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,

135: p_revision IN MTL_ITEM_REVISIONS.revision%TYPE,
136: p_organization_id IN MTL_PARAMETERS.organization_id%TYPE,
137: p_subinventory_code IN MTL_SECONDARY_INVENTORIES.secondary_inventory_name%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,

Line 140: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,

136: p_organization_id IN MTL_PARAMETERS.organization_id%TYPE,
137: p_subinventory_code IN MTL_SECONDARY_INVENTORIES.secondary_inventory_name%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,

Line 153: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%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,
155: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
156: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
157: p_userid IN NUMBER,

Line 232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
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