APPS.INV_INV_LOVS dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1962: FROM mtl_lot_numbers mln, mtl_transaction_lots_temp mtlt,

1958: , mln.expiration_date
1959: , mmst.status_code
1960: , mtlt.primary_quantity
1961: , mtlt.transaction_quantity
1962: FROM mtl_lot_numbers mln, mtl_transaction_lots_temp mtlt,
1963: mtl_material_statuses_tl mmst
1964: WHERE mln.organization_id = p_organization_id
1965: AND mln.inventory_item_id = p_item_id
1966: AND mln.lot_number LIKE (p_lot_number)

Line 1982: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,

1978: , mmst.status_code
1979: , mtlt.primary_quantity
1980: , mtlt.transaction_quantity
1981: FROM mtl_lot_numbers mln,
1982: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,
1983: mtl_material_statuses_tl mmst
1984: WHERE mln.organization_id = p_organization_id
1985: AND mln.inventory_item_id = p_item_id
1986: AND mln.lot_number LIKE (p_lot_number)

Line 2020: mtl_transaction_lots_temp mtlt, mtl_material_statuses_tl mmst

2016: , mmst.status_code
2017: , mtlt.primary_quantity
2018: , mtlt.transaction_quantity
2019: FROM mtl_lot_numbers mln,
2020: mtl_transaction_lots_temp mtlt, mtl_material_statuses_tl mmst
2021: WHERE mln.organization_id = p_organization_id
2022: AND mln.inventory_item_id = p_item_id
2023: AND mln.lot_number LIKE (p_lot_number)
2024: AND mln.status_id = mmst.status_id (+)

Line 2045: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,

2041: , mmst.status_code
2042: , mtlt.primary_quantity
2043: , mtlt.transaction_quantity
2044: FROM mtl_lot_numbers mln,
2045: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,
2046: mtl_material_statuses_tl mmst
2047: WHERE mln.organization_id = p_organization_id
2048: AND mln.inventory_item_id = p_item_id
2049: AND mln.lot_number LIKE (p_lot_number)

Line 2125: mtl_transaction_lots_temp mtlt, wms_allocations_gtmp mag,

2121: , mmst.status_code
2122: , sum(mag.primary_quantity)
2123: , sum(mag.transaction_quantity)
2124: FROM mtl_lot_numbers mln,
2125: mtl_transaction_lots_temp mtlt, wms_allocations_gtmp mag,
2126: mtl_material_statuses_tl mmst
2127: WHERE mln.organization_id = p_organization_id
2128: AND mln.inventory_item_id = p_item_id
2129: AND mln.lot_number LIKE (p_lot_number)

Line 2189: FROM mtl_transaction_lots_temp

2185: SELECT lot_number
2186: , ' '
2187: , ' '
2188: , ' '
2189: FROM mtl_transaction_lots_temp
2190: WHERE transaction_temp_id = p_temp_id;
2191: END get_lot_lov_for_unload;
2192:
2193: -- Name: GET_FORMAT_LOV