APPS.INV_LOT_API_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 449: FROM mtl_transaction_lots_temp

445: TO_CHAR ( n_attribute9 ),
446: territory_code,
447: vendor_name,
448: description
449: FROM mtl_transaction_lots_temp
450: WHERE lot_number = p_lot_number
451: AND transaction_temp_id = p_trx_temp_id;
452: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
453: BEGIN

Line 1073: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

1069: mtlt.n_attribute10,
1070: mtlt.territory_code,
1071: mtlt.vendor_name,
1072: p_parent_lot_number -- bug 10176719 - inserting parent_lot_number
1073: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
1074: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
1075: AND mtlt.lot_number = p_lot_number
1076: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1077: AND NOT EXISTS ( SELECT NULL

Line 1680: FROM mtl_transaction_lots_temp

1676: supplier_lot_number,
1677: TO_CHAR ( n_attribute9 ),
1678: territory_code,
1679: vendor_name
1680: FROM mtl_transaction_lots_temp
1681: WHERE lot_number = p_lot_number
1682: AND transaction_temp_id = p_trx_temp_id;
1683: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1684: BEGIN

Line 1839: FROM mtl_transaction_lots_temp

1835: /* SELECT transaction_quantity,
1836: primary_quantity
1837: INTO l_transaction_quantity,
1838: l_primary_quantity
1839: FROM mtl_transaction_lots_temp
1840: WHERE transaction_temp_id = p_transaction_temp_id
1841: AND lot_number = p_lot_number;
1842: */
1843:

Line 2020: mtl_transaction_lots_temp MTLT

2016: MLN.vendor_name,
2017: mtlt.product_code,
2018: mtlt.product_transaction_id
2019: FROM mtl_lot_numbers MLN,
2020: mtl_transaction_lots_temp MTLT
2021: WHERE MLN.organization_id = p_organization_id
2022: AND MLN.inventory_item_id = p_inventory_item_id
2023: AND MLN.lot_number = p_lot_number
2024: AND MTLT.lot_number = MLN.lot_number

Line 2331: FROM mtl_transaction_lots_temp mtlt

2327: g_lot_attributes_tbl ( 66 ).column_value,
2328: g_lot_attributes_tbl ( 67 ).column_value,
2329: mtlt.product_code,
2330: mtlt.product_transaction_id
2331: FROM mtl_transaction_lots_temp mtlt
2332: WHERE transaction_temp_id = p_transaction_temp_id
2333: AND lot_number = p_lot_number
2334: -- Hack for bug 2130268
2335: -- What if any transaction has the same lot 'p_lot_number' twice !!

Line 2444: FROM mtl_transaction_lots_temp lot,

2440:
2441: CURSOR mtlt_cur_2
2442: IS
2443: SELECT lot.lot_number
2444: FROM mtl_transaction_lots_temp lot,
2445: mtl_material_transactions_temp mmtt
2446: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
2447: AND lot.lot_number = p_auto_lot_number
2448: AND mmtt.inventory_item_id <> p_inventory_item_id;

Line 2770: FROM mtl_transaction_lots_temp lot,

2766: table.
2767: Removed check for existing parent lot.
2768: CURSOR mtlt_cur_1 IS
2769: SELECT lot.lot_number
2770: FROM mtl_transaction_lots_temp lot,
2771: mtl_material_transactions_temp mmtt
2772: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
2773: AND lot.lot_number = p_parent_lot_number
2774: AND inventory_item_id = p_inventory_item_id;

Line 3653: FROM mtl_transaction_lots_temp lot,

3649:
3650: CURSOR mtlt_cur_1
3651: IS
3652: SELECT lot.lot_number
3653: FROM mtl_transaction_lots_temp lot,
3654: mtl_material_transactions_temp mmtt
3655: WHERE lot.transaction_temp_id = mmtt.transaction_temp_id
3656: AND lot.lot_number = p_auto_lot_number
3657: AND mmtt.inventory_item_id = p_inventory_item_id;