APPS.INV_LOT_API_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1725: INSERT INTO mtl_transaction_lot_numbers

1721: WHERE transaction_temp_id = p_transaction_temp_id
1722: AND lot_number = p_lot_number;
1723: */
1724:
1725: INSERT INTO mtl_transaction_lot_numbers
1726: (
1727: transaction_id,
1728: last_update_date,
1729: last_updated_by,

Line 1910: from mtl_transaction_lot_numbers mtln

1906: AND MTLT.transaction_temp_id = p_transaction_temp_id
1907: -- AND MTLT.LOT_NUMBER = p_lot_number
1908: and not exists (
1909: select null
1910: from mtl_transaction_lot_numbers mtln
1911: where mtln.lot_number = p_lot_number
1912: and mtln.primary_quantity = round(abs(MTLT.PRIMARY_QUANTITY),5)
1913: and mtln.inventory_item_id = p_inventory_item_id
1914: and mtln.organization_id = p_organization_id

Line 1996: INSERT INTO mtl_transaction_lot_numbers

1992: p_inventory_item_id,
1993: 'Lot Attributes'
1994: );
1995:
1996: INSERT INTO mtl_transaction_lot_numbers
1997: (
1998: transaction_id,
1999: last_update_date,
2000: last_updated_by,

Line 2221: FROM mtl_transaction_lot_numbers mtln

2217: -- The insert statement then inserts two records instead of one,
2218: -- hence the following 'not exists' clause
2219: AND NOT EXISTS (
2220: SELECT NULL
2221: FROM mtl_transaction_lot_numbers mtln
2222: WHERE mtln.lot_number = p_lot_number
2223: AND mtln.primary_quantity =
2224: DECODE (
2225: l_mmtt_pri_quantity,

Line 2318: FROM mtl_transaction_lot_numbers

2314:
2315: CURSOR mtln_cur_2
2316: IS
2317: SELECT lot_number
2318: FROM mtl_transaction_lot_numbers
2319: WHERE lot_number = p_auto_lot_number
2320: AND inventory_item_id <> p_inventory_item_id;
2321:
2322: CURSOR mtlt_cur_2

Line 3487: FROM mtl_transaction_lot_numbers

3483:
3484: CURSOR mtln_cur_1
3485: IS
3486: SELECT lot_number
3487: FROM mtl_transaction_lot_numbers
3488: WHERE lot_number = p_auto_lot_number
3489: AND inventory_item_id = p_inventory_item_id;
3490:
3491: CURSOR mtlt_cur_1