APPS.INV_LOT_API_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1844: INSERT INTO mtl_transaction_lot_numbers

1840: WHERE transaction_temp_id = p_transaction_temp_id
1841: AND lot_number = p_lot_number;
1842: */
1843:
1844: INSERT INTO mtl_transaction_lot_numbers
1845: (
1846: transaction_id,
1847: last_update_date,
1848: last_updated_by,

Line 2029: from mtl_transaction_lot_numbers mtln

2025: AND MTLT.transaction_temp_id = p_transaction_temp_id
2026: -- AND MTLT.LOT_NUMBER = p_lot_number
2027: and not exists (
2028: select null
2029: from mtl_transaction_lot_numbers mtln
2030: where mtln.lot_number = p_lot_number
2031: and mtln.primary_quantity = round(abs(MTLT.PRIMARY_QUANTITY),5)
2032: and mtln.inventory_item_id = p_inventory_item_id
2033: and mtln.organization_id = p_organization_id

Line 2115: INSERT INTO mtl_transaction_lot_numbers

2111: p_inventory_item_id,
2112: 'Lot Attributes'
2113: );
2114:
2115: INSERT INTO mtl_transaction_lot_numbers
2116: (
2117: transaction_id,
2118: last_update_date,
2119: last_updated_by,

Line 2340: FROM mtl_transaction_lot_numbers mtln

2336: -- The insert statement then inserts two records instead of one,
2337: -- hence the following 'not exists' clause
2338: AND NOT EXISTS (
2339: SELECT NULL
2340: FROM mtl_transaction_lot_numbers mtln
2341: WHERE mtln.lot_number = p_lot_number
2342: AND mtln.primary_quantity =
2343: DECODE (
2344: l_mmtt_pri_quantity,

Line 2437: FROM mtl_transaction_lot_numbers

2433:
2434: CURSOR mtln_cur_2
2435: IS
2436: SELECT lot_number
2437: FROM mtl_transaction_lot_numbers
2438: WHERE lot_number = p_auto_lot_number
2439: AND inventory_item_id <> p_inventory_item_id;
2440:
2441: CURSOR mtlt_cur_2

Line 3646: FROM mtl_transaction_lot_numbers

3642:
3643: CURSOR mtln_cur_1
3644: IS
3645: SELECT lot_number
3646: FROM mtl_transaction_lot_numbers
3647: WHERE lot_number = p_auto_lot_number
3648: AND inventory_item_id = p_inventory_item_id;
3649:
3650: CURSOR mtlt_cur_1

Line 8735: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt

8731:
8732: /*Bug#9717803 any issue transaction other than the misc issue */
8733: CURSOR cur_any_consumptions IS
8734: SELECT 1
8735: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt
8736: WHERE mtln.organization_id = p_organization_id
8737: AND mtln.inventory_item_id = p_inventory_item_id
8738: AND mtln.lot_number = p_lot_number
8739: AND mtln.transaction_id = mmt.transaction_id