DBA Data[Home] [Help]

APPS.FLM_KANBANCARD_PUB dependencies on RCV_TRANSACTIONS

Line 1108: from rcv_transactions rt,

1104: else
1105: mydebug('Intransit Parameters: orgid='||l_kanban_card_rec.organization_id||', inv_item_id='||l_kanban_card_rec.inventory_item_id||', subinv_code='||l_kanban_card_rec.subinventory_name||', txn_src_type='||l_transaction_source_type_id);
1106: select nvl(sum(primary_quantity),0)
1107: into l_total_received_quantity
1108: from rcv_transactions rt,
1109: mtl_kanban_card_activity mkca,
1110: mtl_kanban_cards mkc
1111: where rt.transaction_type = 'DELIVER'
1112: and rt.requisition_line_id = mkca.document_detail_id