DBA Data[Home] [Help]

APPS.INV_SELECT_INVENTORY_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 94: FROM mtl_material_transactions_temp trans, mtl_transaction_lots_temp lots, mtl_lot_numbers mln

90: 0 onhand_quantity,0 secondary_onhand_qty,lots.reason_id,
91: decode(lots.transaction_quantity,null,trans.transaction_quantity,lots.transaction_quantity),
92: decode(lots.secondary_quantity,null,trans.secondary_transaction_quantity,lots.secondary_quantity),
93: trans.transaction_uom,trans.secondary_uom_code,trans.revision,1
94: FROM mtl_material_transactions_temp trans, mtl_transaction_lots_temp lots, mtl_lot_numbers mln
95: WHERE trans.move_order_line_id = V_move_order_line_id
96: AND trans.organization_id = mln.organization_id (+)
97: AND trans.inventory_item_id = mln.inventory_item_id (+)
98: AND trans.transaction_temp_id = lots.transaction_temp_id (+)