DBA Data[Home] [Help]

APPS.FLM_KANBANCARD_PUB dependencies on OE_ORDER_LINES_ALL

Line 1082: oe_order_lines_all ool,

1078: mydebug('Direct Trf 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);
1079: select nvl(sum(mmt.primary_quantity),0)
1080: into l_total_received_quantity
1081: from mtl_material_transactions mmt,
1082: oe_order_lines_all ool,
1083: (select mkca.document_header_id,mkca.document_detail_id
1084: from mtl_kanban_cards mkc,mtl_kanban_card_activity mkca
1085: where mkc.kanban_card_id = p_Kanban_Card_Id
1086: and mkc.kanban_card_id = mkca.kanban_card_id