DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1874: from MTL_TRANSACTION_LOT_NUMBERS mtln

1870: p_comp_item_id => p_comp_item_id);
1871: elsif p_comp_code = 2 then
1872: select abs(nvl(sum(mtln.transaction_quantity),0))
1873: into l_issue_qty
1874: from MTL_TRANSACTION_LOT_NUMBERS mtln
1875: where mtln.transaction_source_type_id = 5
1876: and mtln.transaction_source_id = p_job_id
1877: and mtln.parent_object_type = 2
1878: and mtln.parent_object_number = p_assy_serial