APPS.INV_INV_LOVS dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1986: FROM mtl_lot_numbers mln, mtl_transaction_lots_temp mtlt,

1982: , mln.expiration_date
1983: , mmst.status_code
1984: , mtlt.primary_quantity
1985: , mtlt.transaction_quantity
1986: FROM mtl_lot_numbers mln, mtl_transaction_lots_temp mtlt,
1987: mtl_material_statuses_tl mmst
1988: WHERE mln.organization_id = p_organization_id
1989: AND mln.inventory_item_id = p_item_id
1990: AND mln.lot_number LIKE (p_lot_number)

Line 2006: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,

2002: , mmst.status_code
2003: , mtlt.primary_quantity
2004: , mtlt.transaction_quantity
2005: FROM mtl_lot_numbers mln,
2006: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,
2007: mtl_material_statuses_tl mmst
2008: WHERE mln.organization_id = p_organization_id
2009: AND mln.inventory_item_id = p_item_id
2010: AND mln.lot_number LIKE (p_lot_number)

Line 2044: mtl_transaction_lots_temp mtlt, mtl_material_statuses_tl mmst

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

Line 2069: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,

2065: , mmst.status_code
2066: , mtlt.primary_quantity
2067: , mtlt.transaction_quantity
2068: FROM mtl_lot_numbers mln,
2069: mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc,
2070: mtl_material_statuses_tl mmst
2071: WHERE mln.organization_id = p_organization_id
2072: AND mln.inventory_item_id = p_item_id
2073: AND mln.lot_number LIKE (p_lot_number)

Line 2150: mtl_transaction_lots_temp mtlt, wms_allocations_gtmp mag,

2146: , mmst.status_code
2147: , sum(mag.primary_quantity)
2148: , sum(mag.transaction_quantity)
2149: FROM mtl_lot_numbers mln,
2150: mtl_transaction_lots_temp mtlt, wms_allocations_gtmp mag,
2151: mtl_material_statuses_tl mmst
2152: WHERE mln.organization_id = p_organization_id
2153: AND mln.inventory_item_id = p_item_id
2154: AND mln.lot_number LIKE (p_lot_number)

Line 2219: FROM mtl_transaction_lots_temp

2215: SELECT lot_number
2216: , ' '
2217: , ' '
2218: , ' '
2219: FROM mtl_transaction_lots_temp
2220: WHERE transaction_temp_id = p_temp_id;
2221: END get_lot_lov_for_unload;
2222:
2223: -- Name: GET_FORMAT_LOV