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_KANBAN_PUB dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 19: FUNCTION get_pull_sequence_id (p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE

15: inv_log_util.trace(msg, 'FLM_KANBAN_PUB', 9);
16: END mydebug;
17:
18: -- private funtion to get pull sequence id
19: FUNCTION get_pull_sequence_id (p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
20: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
21: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
22: ,p_subinv_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
23: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE )

Line 20: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE

16: END mydebug;
17:
18: -- private funtion to get pull sequence id
19: FUNCTION get_pull_sequence_id (p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
20: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
21: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
22: ,p_subinv_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
23: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE )
24: RETURN NUMBER

Line 21: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE

17:
18: -- private funtion to get pull sequence id
19: FUNCTION get_pull_sequence_id (p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
20: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
21: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
22: ,p_subinv_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
23: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE )
24: RETURN NUMBER
25: IS

Line 22: ,p_subinv_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE

18: -- private funtion to get pull sequence id
19: FUNCTION get_pull_sequence_id (p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
20: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
21: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
22: ,p_subinv_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
23: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE )
24: RETURN NUMBER
25: IS
26: CURSOR c_pull_seq_id

Line 23: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE )

19: FUNCTION get_pull_sequence_id (p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
20: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
21: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
22: ,p_subinv_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
23: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE )
24: RETURN NUMBER
25: IS
26: CURSOR c_pull_seq_id
27: IS

Line 29: FROM mtl_kanban_pull_sequences mkps

25: IS
26: CURSOR c_pull_seq_id
27: IS
28: SELECT mkps.pull_sequence_id
29: FROM mtl_kanban_pull_sequences mkps
30: WHERE mkps.inventory_item_id = p_invitem_id
31: AND mkps.organization_id = p_org_id
32: AND mkps.kanban_plan_id = NVL(p_kan_plan_id,mkps.kanban_plan_id)
33: AND TRIM ( mkps.subinventory_name ) = TRIM( p_subinv_name )

Line 36: l_pull_seq_id mtl_kanban_pull_sequences.pull_sequence_id%type;

32: AND mkps.kanban_plan_id = NVL(p_kan_plan_id,mkps.kanban_plan_id)
33: AND TRIM ( mkps.subinventory_name ) = TRIM( p_subinv_name )
34: AND NVL ( mkps.locator_id,-1 ) = NVL ( p_loc_id,-1 );
35:
36: l_pull_seq_id mtl_kanban_pull_sequences.pull_sequence_id%type;
37: BEGIN
38: OPEN c_pull_seq_id;
39: FETCH c_pull_seq_id INTO l_pull_seq_id;
40: CLOSE c_pull_seq_id;

Line 53: from mtl_kanban_pull_sequences

49: l_exist number;
50: begin
51: select 1
52: into l_exist
53: from mtl_kanban_pull_sequences
54: where pull_sequence_id = p_pull_seq_id;
55:
56: return TRUE;
57: exception

Line 120: function is_inv_item_id_valid(p_inv_item_id in mtl_kanban_pull_sequences.inventory_item_id%TYPE

116: return false;
117: end is_lookup_code_valid;
118:
119: -- private function to validate inventory item id
120: function is_inv_item_id_valid(p_inv_item_id in mtl_kanban_pull_sequences.inventory_item_id%TYPE
121: ,p_org_id in mtl_kanban_pull_sequences.organization_id%TYPE)
122: return boolean
123: is
124: l_exist number;

Line 121: ,p_org_id in mtl_kanban_pull_sequences.organization_id%TYPE)

117: end is_lookup_code_valid;
118:
119: -- private function to validate inventory item id
120: function is_inv_item_id_valid(p_inv_item_id in mtl_kanban_pull_sequences.inventory_item_id%TYPE
121: ,p_org_id in mtl_kanban_pull_sequences.organization_id%TYPE)
122: return boolean
123: is
124: l_exist number;
125: begin

Line 490: CURSOR c_pull_seq_data(p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE

486: ,x_ret_status OUT NOCOPY VARCHAR2
487: ,x_error_msg OUT NOCOPY VARCHAR2)
488: is
489: /*-- cursor to get pull seq data
490: CURSOR c_pull_seq_data(p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
491: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
492: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
493: ,p_sub_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
494: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE)

Line 491: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE

487: ,x_error_msg OUT NOCOPY VARCHAR2)
488: is
489: /*-- cursor to get pull seq data
490: CURSOR c_pull_seq_data(p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
491: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
492: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
493: ,p_sub_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
494: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE)
495: IS

Line 492: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE

488: is
489: /*-- cursor to get pull seq data
490: CURSOR c_pull_seq_data(p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
491: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
492: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
493: ,p_sub_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
494: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE)
495: IS
496: SELECT mkps.inventory_item_id

Line 493: ,p_sub_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE

489: /*-- cursor to get pull seq data
490: CURSOR c_pull_seq_data(p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
491: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
492: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
493: ,p_sub_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
494: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE)
495: IS
496: SELECT mkps.inventory_item_id
497: ,mkps.organization_id

Line 494: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE)

490: CURSOR c_pull_seq_data(p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE
491: ,p_org_id IN mtl_kanban_pull_sequences.organization_id%TYPE
492: ,p_kan_plan_id IN mtl_kanban_pull_sequences.kanban_plan_id%TYPE
493: ,p_sub_name IN mtl_kanban_pull_sequences.subinventory_name%TYPE
494: ,p_loc_id IN mtl_kanban_pull_sequences.locator_id%TYPE)
495: IS
496: SELECT mkps.inventory_item_id
497: ,mkps.organization_id
498: ,mkps.kanban_plan_id

Line 511: FROM mtl_kanban_pull_sequences mkps

507: ,mkps.kanban_size
508: ,mkps.calculate_kanban_flag
509: ,mkps.number_of_cards
510: ,mkps.release_kanban_flag
511: FROM mtl_kanban_pull_sequences mkps
512: WHERE mkps.inventory_item_id = p_invitem_id
513: AND mkps.organization_id = p_org_id
514: AND mkps.kanban_plan_id = p_kan_plan_id
515: AND trim ( mkps.subinventory_name ) = trim( p_sub_name )

Line 554: CURSOR c_pull_seq_calc (p_kanban_size IN mtl_kanban_pull_sequences.kanban_size%TYPE

550: OR misi.disable_date IS NULL )
551: AND misi.organization_id = p_org_id;
552:
553: -- cursor to validate number of cards/kanban size
554: CURSOR c_pull_seq_calc (p_kanban_size IN mtl_kanban_pull_sequences.kanban_size%TYPE
555: ,p_calculate_kanban_flag IN mtl_kanban_pull_sequences.calculate_kanban_flag%TYPE
556: ,p_number_of_cards IN mtl_kanban_pull_sequences.number_of_cards%TYPE
557: ,p_release_kanban_flag IN mtl_kanban_pull_sequences.release_kanban_flag%TYPE
558: ,p_pull_sequence_id IN mtl_kanban_pull_sequences.pull_sequence_id%TYPE

Line 555: ,p_calculate_kanban_flag IN mtl_kanban_pull_sequences.calculate_kanban_flag%TYPE

551: AND misi.organization_id = p_org_id;
552:
553: -- cursor to validate number of cards/kanban size
554: CURSOR c_pull_seq_calc (p_kanban_size IN mtl_kanban_pull_sequences.kanban_size%TYPE
555: ,p_calculate_kanban_flag IN mtl_kanban_pull_sequences.calculate_kanban_flag%TYPE
556: ,p_number_of_cards IN mtl_kanban_pull_sequences.number_of_cards%TYPE
557: ,p_release_kanban_flag IN mtl_kanban_pull_sequences.release_kanban_flag%TYPE
558: ,p_pull_sequence_id IN mtl_kanban_pull_sequences.pull_sequence_id%TYPE
559: ,p_source_subinventory IN mtl_kanban_pull_sequences.source_subinventory%TYPE)

Line 556: ,p_number_of_cards IN mtl_kanban_pull_sequences.number_of_cards%TYPE

552:
553: -- cursor to validate number of cards/kanban size
554: CURSOR c_pull_seq_calc (p_kanban_size IN mtl_kanban_pull_sequences.kanban_size%TYPE
555: ,p_calculate_kanban_flag IN mtl_kanban_pull_sequences.calculate_kanban_flag%TYPE
556: ,p_number_of_cards IN mtl_kanban_pull_sequences.number_of_cards%TYPE
557: ,p_release_kanban_flag IN mtl_kanban_pull_sequences.release_kanban_flag%TYPE
558: ,p_pull_sequence_id IN mtl_kanban_pull_sequences.pull_sequence_id%TYPE
559: ,p_source_subinventory IN mtl_kanban_pull_sequences.source_subinventory%TYPE)
560: IS

Line 557: ,p_release_kanban_flag IN mtl_kanban_pull_sequences.release_kanban_flag%TYPE

553: -- cursor to validate number of cards/kanban size
554: CURSOR c_pull_seq_calc (p_kanban_size IN mtl_kanban_pull_sequences.kanban_size%TYPE
555: ,p_calculate_kanban_flag IN mtl_kanban_pull_sequences.calculate_kanban_flag%TYPE
556: ,p_number_of_cards IN mtl_kanban_pull_sequences.number_of_cards%TYPE
557: ,p_release_kanban_flag IN mtl_kanban_pull_sequences.release_kanban_flag%TYPE
558: ,p_pull_sequence_id IN mtl_kanban_pull_sequences.pull_sequence_id%TYPE
559: ,p_source_subinventory IN mtl_kanban_pull_sequences.source_subinventory%TYPE)
560: IS
561: SELECT NVL(p_kanban_size, mkps.kanban_size) kanban_size

Line 558: ,p_pull_sequence_id IN mtl_kanban_pull_sequences.pull_sequence_id%TYPE

554: CURSOR c_pull_seq_calc (p_kanban_size IN mtl_kanban_pull_sequences.kanban_size%TYPE
555: ,p_calculate_kanban_flag IN mtl_kanban_pull_sequences.calculate_kanban_flag%TYPE
556: ,p_number_of_cards IN mtl_kanban_pull_sequences.number_of_cards%TYPE
557: ,p_release_kanban_flag IN mtl_kanban_pull_sequences.release_kanban_flag%TYPE
558: ,p_pull_sequence_id IN mtl_kanban_pull_sequences.pull_sequence_id%TYPE
559: ,p_source_subinventory IN mtl_kanban_pull_sequences.source_subinventory%TYPE)
560: IS
561: SELECT NVL(p_kanban_size, mkps.kanban_size) kanban_size
562: ,NVL(p_calculate_kanban_flag, mkps.calculate_kanban_flag) calculate_kanban_flag

Line 559: ,p_source_subinventory IN mtl_kanban_pull_sequences.source_subinventory%TYPE)

555: ,p_calculate_kanban_flag IN mtl_kanban_pull_sequences.calculate_kanban_flag%TYPE
556: ,p_number_of_cards IN mtl_kanban_pull_sequences.number_of_cards%TYPE
557: ,p_release_kanban_flag IN mtl_kanban_pull_sequences.release_kanban_flag%TYPE
558: ,p_pull_sequence_id IN mtl_kanban_pull_sequences.pull_sequence_id%TYPE
559: ,p_source_subinventory IN mtl_kanban_pull_sequences.source_subinventory%TYPE)
560: IS
561: SELECT NVL(p_kanban_size, mkps.kanban_size) kanban_size
562: ,NVL(p_calculate_kanban_flag, mkps.calculate_kanban_flag) calculate_kanban_flag
563: ,NVL(p_number_of_cards, mkps.number_of_cards) number_of_cards

Line 568: FROM mtl_kanban_pull_sequences mkps

564: ,NVL(p_release_kanban_flag, mkps.release_kanban_flag) release_kanban_flag
565: ,NVL(p_source_subinventory, mkps.source_subinventory) source_subinventory
566: ,mkps.source_organization_id
567: ,mkps.source_locator_id
568: FROM mtl_kanban_pull_sequences mkps
569: WHERE mkps.pull_sequence_id = p_pull_sequence_id;
570:
571:
572: lr_inv_item c_inv_item%rowtype;

Line 832: FROM mtl_kanban_pull_sequences mkps

828: ,p_pull_seq_rec.avg_dependent_demand
829: ,p_pull_seq_rec.avg_independent_demand
830: ,l_kanban_size
831: ,l_no_of_cards
832: FROM mtl_kanban_pull_sequences mkps
833: WHERE pull_sequence_id = l_pullseq_id;
834:
835: end if;
836:

Line 1736: FROM mtl_kanban_pull_sequences MKPS

1732: ,MKPS.wip_line_id
1733: ,MKPS.number_of_cards
1734: ,MKPS.future_no_of_cards
1735: ,MKPS.release_kanban_flag
1736: FROM mtl_kanban_pull_sequences MKPS
1737: WHERE pull_sequence_id = p_pullseq_id;
1738:
1739: --Cursor to Kanban Card count
1740: CURSOR c_cards_cnt(p_pull_sequence_id IN NUMBER)

Line 3957: -- when updating pull sequence, if source_type is null, derive the source_type from mtl_kanban_pull_sequences table

3953: if l_ret_status = FND_API.G_RET_STS_SUCCESS and
3954: p_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD,FLM_KANBAN_MASSLOAD.KANBAN_CHANGE)
3955: then
3956: -- Fix bug 12402610
3957: -- when updating pull sequence, if source_type is null, derive the source_type from mtl_kanban_pull_sequences table
3958: if (p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE and p_pull_sequence_rec.source_type is null) then
3959: select mkps.source_type
3960: into l_source_type
3961: from mtl_kanban_pull_sequences mkps

Line 3961: from mtl_kanban_pull_sequences mkps

3957: -- when updating pull sequence, if source_type is null, derive the source_type from mtl_kanban_pull_sequences table
3958: if (p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE and p_pull_sequence_rec.source_type is null) then
3959: select mkps.source_type
3960: into l_source_type
3961: from mtl_kanban_pull_sequences mkps
3962: WHERE pull_sequence_id = p_pull_sequence_rec.pull_sequence_id;
3963: p_pull_sequence_rec.source_type := l_source_type;
3964: end if;
3965:

Line 4023: UPDATE mtl_kanban_pull_sequences

4019: mydebug('l_error_msg='||l_error_msg);
4020:
4021: -- Nullify supplier details at pull sequence if multiple suppliers are used
4022: if l_ret_status = FND_API.G_RET_STS_SUCCESS then
4023: UPDATE mtl_kanban_pull_sequences
4024: SET supplier_id = null
4025: ,supplier_site_id = null
4026: WHERE pull_sequence_id = p_pull_sequence_rec.pull_sequence_id;
4027: end if;

Line 4293: mtl_kanban_pull_sequences pull

4289: subinventory_name,locator_id,pull.organization_id
4290: into x_item_name,x_org_code,x_subinventory,l_locator_id,
4291: l_organization_id
4292: from mtl_system_items_kfv a , mtl_parameters b,
4293: mtl_kanban_pull_sequences pull
4294: where a.inventory_item_id = pull.inventory_item_id
4295: and a.organization_id = Pull.organization_id
4296: and b.organization_id = Pull.organization_id
4297: and pull.pull_sequence_id = p_Pull_sequence_id;