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.INV_KANBAN_PVT dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 1420: from mtl_kanban_card_activity

1416: Return TRUE;
1417: else
1418: begin
1419: select 'x' into l_dummy
1420: from mtl_kanban_card_activity
1421: where kanban_card_id = p_kanban_id
1422: and organization_id = p_org_id
1423: and document_header_id = p_wip_entity_id
1424: and source_type = INV_KANBAN_PVT.G_Source_Type_Production

Line 3774: FROM mtl_kanban_card_activity

3770: CURSOR mtl_kca IS
3771: SELECT replenishment_cycle_id
3772: , document_header_id
3773: , document_detail_id
3774: FROM mtl_kanban_card_activity
3775: WHERE kanban_card_id = p_kanban_card_id
3776: AND document_header_id IS NOT NULL
3777: ORDER BY kanban_activity_id DESC;
3778:

Line 3810: FROM mtl_kanban_card_activity

3806: SELECT document_type
3807: , replenishment_cycle_id
3808: INTO l_doc_type_id
3809: , l_max_rep_id
3810: FROM mtl_kanban_card_activity
3811: WHERE kanban_card_id = p_kanban_card_id
3812: AND document_type IS NOT NULL
3813: AND document_type <> fnd_api.g_miss_num
3814: AND replenishment_cycle_id = (SELECT MAX(replenishment_cycle_id)

Line 3815: FROM mtl_kanban_card_activity

3811: WHERE kanban_card_id = p_kanban_card_id
3812: AND document_type IS NOT NULL
3813: AND document_type <> fnd_api.g_miss_num
3814: AND replenishment_cycle_id = (SELECT MAX(replenishment_cycle_id)
3815: FROM mtl_kanban_card_activity
3816: WHERE kanban_card_id = p_kanban_card_id);
3817: EXCEPTION
3818: WHEN TOO_MANY_ROWS THEN
3819: mydebug('Multiple document types and maximum replenishment cycle id returned for kanban card Id ' || p_kanban_card_id||' ;Hence disallowing Supply status update');