APPS.INV_OPM_LOT_MIGRATION dependencies on MTL_LOT_NUMBERS

Line 108: l_lot_rec mtl_lot_numbers%ROWTYPE;

104: , x_parent_lot_number IN OUT NOCOPY VARCHAR2
105: , x_failure_count OUT NOCOPY NUMBER
106: ) IS
107: PRAGMA AUTONOMOUS_TRANSACTION;
108: l_lot_rec mtl_lot_numbers%ROWTYPE;
109: o_lot_rec mtl_lot_numbers%ROWTYPE;
110: o_item_rec INV_ITEM_API.Item_rec_type;
111: -- l_error_tbl INV_ITEM_API.Error_tbl_type;
112: l_opm_lot ic_lots_mst%ROWTYPE;

Line 109: o_lot_rec mtl_lot_numbers%ROWTYPE;

105: , x_failure_count OUT NOCOPY NUMBER
106: ) IS
107: PRAGMA AUTONOMOUS_TRANSACTION;
108: l_lot_rec mtl_lot_numbers%ROWTYPE;
109: o_lot_rec mtl_lot_numbers%ROWTYPE;
110: o_item_rec INV_ITEM_API.Item_rec_type;
111: -- l_error_tbl INV_ITEM_API.Error_tbl_type;
112: l_opm_lot ic_lots_mst%ROWTYPE;
113: l_inventory_item_id NUMBER;

Line 402: FROM mtl_lot_numbers

398:
399: -- Check if the lot already exists
400: SELECT count(*)
401: INTO l_count
402: FROM mtl_lot_numbers
403: WHERE
404: organization_id = p_organization_id AND
405: inventory_item_id = l_inventory_item_id AND
406: lot_number = x_lot_number;

Line 543: col2.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and

539: FROM fnd_descr_flex_column_usages col2,
540: fnd_descr_flex_contexts cont2
541: WHERE
542: col2.application_id = 401 and
543: col2.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and
544: col2.enabled_flag = 'Y' and
545: col.application_id = cont2.application_id and
546: col.descriptive_flexfield_name = cont2.descriptive_flexfield_name and
547: col.descriptive_flex_context_code = cont2.descriptive_flex_context_code and

Line 589: cont.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and

585: SELECT cont.descriptive_flex_context_code
586: INTO l_odm_context
587: FROM fnd_descr_flex_contexts cont
588: WHERE cont.application_id = 401 and
589: cont.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and
590: cont.enabled_flag = 'Y' and
591: cont.global_flag = 'N' and
592: rownum = 1;
593: EXCEPTION