DBA Data[Home] [Help]

APPS.FLM_KANBANCARD_PUB dependencies on PO_DISTRIBUTIONS_ALL

Line 1030: -- for supplier kanban, get the qty(quantity_delivered) from po_distributions_all table.

1026:
1027: mydebug('receiving_tolerance='||l_rcv_tolerance);
1028:
1029: -- get the total replenish qty into l_total_received_quantity
1030: -- for supplier kanban, get the qty(quantity_delivered) from po_distributions_all table.
1031: if l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then
1032:
1033: SELECT Nvl(pda.quantity_delivered,0)
1034: INTO l_total_received_quantity

Line 1036: po_distributions_all pda,

1032:
1033: SELECT Nvl(pda.quantity_delivered,0)
1034: INTO l_total_received_quantity
1035: FROM mtl_kanban_card_activity mkca,
1036: po_distributions_all pda,
1037: mtl_kanban_cards mkc
1038: WHERE mkc.kanban_card_id = p_Kanban_Card_Id
1039: AND mkca.document_type IS NOT NULL
1040: AND mkca.document_header_id IS NOT NULL