DBA Data[Home] [Help]

APPS.INV_RCV_AVAILABILITY dependencies on MTL_TXN_REQUEST_LINES

Line 111: FROM mtl_txn_request_lines mtrl

107:
108: BEGIN
109: SELECT Nvl(SUM((quantity-Nvl(quantity_delivered,0))*primary_quantity/quantity),0)
110: INTO l_mol_primary_qty
111: FROM mtl_txn_request_lines mtrl
112: , mtl_txn_request_headers mtrh
113: WHERE mtrh.header_id = mtrl.header_id
114: AND mtrh.move_order_type = 6
115: AND mtrl.organization_id = p_organization_id