DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on MTL_SYSTEM_ITEMS_VL

Line 144: --| mtl_system_items_vl to support multi-languages in Cursor cur_get_item |

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
148:

Line 5615: --| mtl_system_items_vl to support multi-languages in Cursor cur_get_item.|

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
5619: CURSOR Cur_get_item IS

Line 5638: FROM mtl_system_items_vl --Bug 13528160

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:
5642: