eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_KANBANCARD_PUB dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 1035: FROM mtl_kanban_card_activity mkca,

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
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

Line 1055: mtl_kanban_card_activity mkca,

1051: select nvl(sum(qty),0)
1052: into l_total_received_quantity
1053: from ( SELECT nvl(mmt.primary_quantity,0) qty
1054: FROM mtl_material_transactions mmt,
1055: mtl_kanban_card_activity mkca,
1056: mtl_kanban_cards mkc
1057: WHERE mkca.kanban_card_id = p_Kanban_Card_Id
1058: AND mkca.document_type IS NOT NULL
1059: AND mkca.document_header_id IS NOT NULL

Line 1084: from mtl_kanban_cards mkc,mtl_kanban_card_activity mkca

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
1087: and mkc.current_replnsh_cycle_id = mkca.replenishment_cycle_id
1088: and mkca.document_header_id is not null

Line 1109: mtl_kanban_card_activity mkca,

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
1113: and rt.organization_id = mkc.organization_id

Line 1129: mtl_kanban_card_activity mkca,

1125: select nvl(sum(qty),0)
1126: INTO l_total_received_quantity
1127: from ( SELECT nvl(mmt.primary_quantity,0) qty
1128: FROM mtl_material_transactions mmt,
1129: mtl_kanban_card_activity mkca,
1130: mtl_kanban_cards mkc
1131: WHERE mkca.kanban_card_id = p_Kanban_Card_Id
1132: AND mkca.document_type IS NOT NULL
1133: AND mkca.document_header_id IS NOT NULL