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_LOGICAL_KANBAN dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 176: FROM mtl_kanban_card_activity mkca,

172: BEGIN
173: IF (kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_Supplier ) THEN
174: SELECT Nvl(pda.quantity_delivered,0)
175: INTO l_received_quantity
176: FROM mtl_kanban_card_activity mkca,
177: po_distributions_all pda
178: WHERE mkca.kanban_card_id = kanban_rec.kanban_card_id
179: AND mkca.organization_id = kanban_rec.organization_id
180: AND mkca.inventory_item_id = kanban_rec.inventory_item_id

Line 186: FROM mtl_kanban_card_activity

182: AND mkca.document_header_id IS NOT NULL
183: AND mkca.document_header_id = pda.po_header_id
184: AND mkca.kanban_card_id = pda.kanban_card_id
185: AND mkca.replenishment_cycle_id = (SELECT Max(replenishment_cycle_id)
186: FROM mtl_kanban_card_activity
187: WHERE kanban_card_id = kanban_rec.kanban_card_id);
188: ELSE
189:
190: IF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_InterOrg THEN

Line 201: mtl_kanban_card_activity mkca,

197:
198: SELECT Nvl(Sum(mmt.transaction_quantity),0)
199: INTO l_received_quantity
200: FROM mtl_material_transactions mmt,
201: mtl_kanban_card_activity mkca,
202: mtl_kanban_cards mkc
203: WHERE mkca.kanban_card_id = kanban_rec.Kanban_Card_Id
204: AND mkca.document_type IS NOT NULL
205: AND mkca.document_header_id IS NOT NULL