APPS.GMD_SAMPLES_GRP dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 143: --| QZENG 30-Dec-2011 Bug 13528160 Replaced mtl_system_items_b_kfv with |

139: --| we call this new procedure from sampling_event_exist function |
140: --| Otherwise - its old code where cursors look at specifications table |
141: --| RLNAGARA LPN ME 7027149 09-May-2008 Added logic for lpn_id in all |
142: --| the cursors |
143: --| QZENG 30-Dec-2011 Bug 13528160 Replaced mtl_system_items_b_kfv with |
144: --| mtl_system_items_vl to support multi-languages in Cursor cur_get_item |
145: --| in procedure get_item_values. |
146: --+========================================================================+
147: -- End of comments

Line 1355: --l_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;

1351: -- Local Variables
1352: l_return_status VARCHAR2(1);
1353: dummy NUMBER;
1354:
1355: --l_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;
1356: --l_in_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;
1357: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1358: l_primary_uom_code VARCHAR2(3);
1359: from_name VARCHAR2(50);

Line 1356: --l_in_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;

1352: l_return_status VARCHAR2(1);
1353: dummy NUMBER;
1354:
1355: --l_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;
1356: --l_in_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;
1357: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1358: l_primary_uom_code VARCHAR2(3);
1359: from_name VARCHAR2(50);
1360: to_name VARCHAR2(50);

Line 2620: MTL_SYSTEM_ITEMS_b_kfv iim

2616: l_locator_id, -- 50061731
2617: l_subinventory, -- 50061731
2618: l_lpn_id -- 12829066
2619: FROM GMD_SAMPLES gs,
2620: MTL_SYSTEM_ITEMS_b_kfv iim
2621: WHERE gs.sample_id = p_sample_id
2622: AND gs.inventory_item_id = iim.inventory_item_id
2623: AND gs.organization_id = iim.organization_id;
2624:

Line 2654: MTL_SYSTEM_ITEMS_b_kfv iim

2650: l_step_no
2651: FROM GMD_COMPOSITE_SPEC_DISP csd,
2652: GMD_EVENT_SPEC_DISP esd ,
2653: GMD_SAMPLING_EVENTS gse,
2654: MTL_SYSTEM_ITEMS_b_kfv iim
2655: WHERE csd.composite_spec_disp_id = p_composite_spec_disp_id
2656: and csd.event_spec_disp_id = esd.event_spec_disp_id
2657: and esd.sampling_event_id = gse.sampling_event_id
2658: and gse.inventory_item_id = iim.inventory_item_id

Line 3602: FROM mtl_system_items_b_kfv

3598:
3599: -- Bug 4165704: changed for inventory convergence
3600: CURSOR c_item(p_inventory_item_id NUMBER, p_organization_id NUMBER) IS
3601: SELECT 1
3602: FROM mtl_system_items_b_kfv
3603: WHERE organization_id = p_organization_id
3604: AND process_quality_enabled_flag = 'Y'
3605: AND inventory_item_id = p_inventory_item_id;
3606:

Line 4670: FROM mtl_system_items_b_kfv

4666: SELECT concatenated_segments item_no ,
4667: dual_uom_control,
4668: primary_uom_code,
4669: secondary_uom_code
4670: FROM mtl_system_items_b_kfv
4671: WHERE inventory_item_id = p_item_id
4672: AND organization_id = p_sample.organization_id;
4673:
4674: -- bug 4165704: following added for new GME proc

Line 5614: --| QZENG 30-Dec-2011 Bug 13528160 Replaced mtl_system_items_b_kfv with |

5610: --| |
5611: --| HISTORY |
5612: --| Susan Feinstein 07-Jan-2005 Created for inventory convergence |
5613: --| Bug 4165704 |
5614: --| QZENG 30-Dec-2011 Bug 13528160 Replaced mtl_system_items_b_kfv with |
5615: --| mtl_system_items_vl to support multi-languages in Cursor cur_get_item.|
5616: --+========================================================================+
5617: PROCEDURE Get_item_values (p_sample_display IN OUT NOCOPY sample_display_rec)
5618: IS

Line 5637: --FROM mtl_system_items_b_kfv -- comment out, bug 13528160

5633: Indivisible_flag,
5634: Serial_number_control_code, --(must = 0 to generate inv transaction)
5635: process_yield_subinventory, -- replenish subinventory
5636: process_yield_locator_id -- replenish locator_id
5637: --FROM mtl_system_items_b_kfv -- comment out, bug 13528160
5638: FROM mtl_system_items_vl --Bug 13528160
5639: WHERE organization_id = p_sample_display.organization_id
5640: AND inventory_item_id = p_sample_display.inventory_item_id;
5641: