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_PULL_SEQUENCES

Line 92: mtl_kanban_pull_sequences pull

88: subinventory_name,locator_id,pull.organization_id
89: into x_item_name,x_org_code,x_subinventory,l_locator_id,
90: l_organization_id
91: from mtl_system_items_kfv a , mtl_parameters b,
92: mtl_kanban_pull_sequences pull
93: where a.inventory_item_id = pull.inventory_item_id
94: and a.organization_id = Pull.organization_id
95: and b.organization_id = Pull.organization_id
96: and pull.pull_sequence_id = p_Pull_sequence_id;

Line 128: From mtl_kanban_pull_sequences

124: IS
125:
126: Cursor Get_Pull_Sequences IS
127: Select pull_sequence_id
128: From mtl_kanban_pull_sequences
129: Where kanban_plan_id = p_kanban_plan_id;
130:
131: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
132:

Line 147: Delete from Mtl_kanban_pull_sequences

143: Raise FND_API.G_EXC_ERROR;
144: end if;
145: end loop;
146: Else
147: Delete from Mtl_kanban_pull_sequences
148: Where kanban_plan_id = p_kanban_plan_id;
149: end if;
150: x_return_status := l_return_status;
151:

Line 268: -- MTL_KANBAN_PULL_SEQUENCES with data from the record.

264: End Validate_Pull_Sequence;
265: --
266: --
267: -- Insert_Pull_Sequence : This procedure inserts record in
268: -- MTL_KANBAN_PULL_SEQUENCES with data from the record.
269: --
270: --
271: PROCEDURE Insert_Pull_Sequence
272: (x_return_status Out NOCOPY Varchar2,

Line 320: -- MTL_KANBAN_PULL_SEQUENCES with data from the

316: End Insert_Pull_sequence;
317: --
318: --
319: -- Update_Pull_Sequence : This procedure Updates the record in
320: -- MTL_KANBAN_PULL_SEQUENCES with data from the
321: -- record.
322: --
323: --
324: PROCEDURE Update_Pull_sequence

Line 364: From Mtl_Kanban_Pull_Sequences

360: then
361: Begin
362: Select Pull_Sequence_Id
363: Into l_Pull_Sequence_Rec.Pull_Sequence_Id
364: From Mtl_Kanban_Pull_Sequences
365: Where Kanban_Plan_Id = l_pull_Sequence_Rec.Kanban_plan_id
366: And Organization_Id = l_pull_Sequence_Rec.Organization_Id
367: And Inventory_Item_Id = l_pull_Sequence_Rec.Inventory_Item_Id
368: And Subinventory_Name = l_pull_Sequence_Rec.Subinventory_Name

Line 464: -- MTL_KANBAN_PULL_SEQUENCES with data from the

460:
461: End Update_Pull_sequence;
462: --
463: --Update_Pull_Sequence_Tbl : This procedure Updates the records in
464: -- MTL_KANBAN_PULL_SEQUENCES with data from the
465: -- table of pull sequences id's passed to it.
466: -- It generates and prints kanban cards as well.
467: ------------------------------------------------------------------------------
468: -- PROCEDURE : UPDATE_PULL_SEQUENCE_TBL

Line 491: CURSOR C2 IS SELECT mtl_kanban_pull_sequences_s.nextval FROM sys.dual;

487: l_report_generate_id NUMBER := 0; --Report id for generating cards
488: l_report_print_id NUMBER := 0; --Report id for printing cards
489: l_count_generate NUMBER := 0; --Count of number of cards to be generated
490: l_count_print NUMBER := 0; -- Count of number of cards to be printed
491: CURSOR C2 IS SELECT mtl_kanban_pull_sequences_s.nextval FROM sys.dual;
492: --Get new pull_sequence_id during insert.
493:
494: Begin
495: FND_MSG_PUB.initialize;

Line 514: UPDATE mtl_kanban_pull_sequences

510: IF X_UPDATE_FLAG = 'Y' THEN
511: v_generate_cards := TRUE;
512: IF(l_pull_sequence_rec.planning_update_status = 1) THEN
513: l_pull_sequence_rec.planning_update_status := NULL ;
514: UPDATE mtl_kanban_pull_sequences
515: SET planning_update_status = NULL
516: WHERE pull_sequence_id = l_pull_sequence_rec.pull_sequence_id;
517: END IF;
518:

Line 2020: from MTL_KANBAN_PULL_SEQUENCES

2016: -- eKanban Changes.
2017: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1) then
2018: if p_kanban_card_rec_tbl(1).pull_sequence_id is not null then
2019: select CONSOLIDATION into l_consolidation_option
2020: from MTL_KANBAN_PULL_SEQUENCES
2021: where pull_sequence_id =p_kanban_card_rec_tbl(1).pull_sequence_id;
2022: if l_consolidation_option <> G_consolidate_opt_yes then
2023: l_group_code := p_kanban_card_rec_tbl(1).pull_sequence_id||
2024: p_kanban_card_rec_tbl(1).kanban_card_id||

Line 2388: FROM Mtl_Kanban_Pull_Sequences MKP

2384: /*Fix for 3905884
2385: IF Auto_Allocate_Flag= 1 (Yes) , allocate move order */
2386: BEGIN
2387: SELECT MKP.auto_allocate_flag INTO l_auto_Allocate_flag
2388: FROM Mtl_Kanban_Pull_Sequences MKP
2389: WHERE MKP.pull_sequence_id=p_kanban_card_rec_tbl(1).pull_sequence_id;
2390: EXCEPTION
2391: WHEN OTHERS THEN
2392: l_auto_Allocate_flag := 0;

Line 3713: l_Pull_Sequence_Rec Mtl_Kanban_Pull_Sequences%RowType;

3709: X_Current_Replenish_Cycle_Id Out NOCOPY Number,
3710: P_Kanban_Card_Rec In Out NOCOPY INV_Kanban_PVT.Kanban_Card_Rec_Type)
3711: IS
3712:
3713: l_Pull_Sequence_Rec Mtl_Kanban_Pull_Sequences%RowType;
3714: l_Wait_Kanban_card_Tbl Kanban_Card_Tbl_Type;
3715: l_Kanban_Card_Rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
3716: l_Wait_Kanban_Size Number := 0;
3717: l_Card_Count Number := 0;

Line 3767: From Mtl_Kanban_Pull_Sequences

3763: X_Current_Replenish_Cycle_Id := l_Current_Replenish_Cycle_Id;
3764: else
3765: Select *
3766: Into l_Pull_Sequence_Rec
3767: From Mtl_Kanban_Pull_Sequences
3768: Where Pull_Sequence_Id = P_Kanban_Card_Rec.Pull_Sequence_Id
3769: For Update Of Minimum_Order_Quantity NOWait;
3770:
3771: If nvl(l_Pull_Sequence_Rec.Minimum_Order_Quantity,0) = 0 Then

Line 3915: For pull_seq_rec IN (select pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES

3911: keep in synch with the call to procedure update_pull_sequence_tbl */
3912: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3913: begin
3914:
3915: For pull_seq_rec IN (select pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES
3916: Where Kanban_plan_id = -1 ) LOOP
3917: i := i + 1;
3918: l_pull_seq_id_tbl(i) := pull_seq_rec.pull_sequence_id ;
3919: l_operation_tbl(i) := 0; --Storing 0 for update