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.GMD_SAMPLES_GRP dependencies on MTL_SYSTEM_ITEMS

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 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 1345: Cursor fetch_mtl_system_items IS

1341: , p_operation IN VARCHAR2
1342: , x_return_status OUT NOCOPY VARCHAR2
1343: ) IS
1344:
1345: Cursor fetch_mtl_system_items IS
1346: SELECT primary_uom_code
1347: FROM mtl_system_items_b
1348: WHERE inventory_item_id = p_sample.inventory_item_id
1349: AND organization_id = p_sample.organization_id;

Line 1347: FROM mtl_system_items_b

1343: ) IS
1344:
1345: Cursor fetch_mtl_system_items IS
1346: SELECT primary_uom_code
1347: FROM mtl_system_items_b
1348: WHERE inventory_item_id = p_sample.inventory_item_id
1349: AND organization_id = p_sample.organization_id;
1350:
1351: -- Local Variables

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 1455: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst

1451: END IF;
1452:
1453: -- Sample Quantity UOM must be convertible to Item's UOM
1454: IF p_sample.sample_type = 'I' THEN
1455: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst
1456: --l_in_item_mst.inventory_item_id := p_sample.inventory_item_id;
1457: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN
1458: -- RAISE e_error_fetch_item;
1459: --END IF;

Line 1461: OPEN fetch_mtl_system_items;

1457: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN
1458: -- RAISE e_error_fetch_item;
1459: --END IF;
1460:
1461: OPEN fetch_mtl_system_items;
1462: FETCH fetch_mtl_system_items into l_primary_uom_code;
1463: CLOSE fetch_mtl_system_items;
1464: END IF;
1465:

Line 1462: FETCH fetch_mtl_system_items into l_primary_uom_code;

1458: -- RAISE e_error_fetch_item;
1459: --END IF;
1460:
1461: OPEN fetch_mtl_system_items;
1462: FETCH fetch_mtl_system_items into l_primary_uom_code;
1463: CLOSE fetch_mtl_system_items;
1464: END IF;
1465:
1466: BEGIN

Line 1463: CLOSE fetch_mtl_system_items;

1459: --END IF;
1460:
1461: OPEN fetch_mtl_system_items;
1462: FETCH fetch_mtl_system_items into l_primary_uom_code;
1463: CLOSE fetch_mtl_system_items;
1464: END IF;
1465:
1466: BEGIN
1467: -- UOM conversion is only needed for Material samples

Line 2419: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;

2415: l_data VARCHAR2(2000);
2416: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
2417: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;
2418: L_Inventory_item_number VARCHAR2(2000);
2419: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
2420: l_organization_id NUMBER;
2421: l_batch_id NUMBER(15);
2422: l_step_no NUMBER(10);
2423: l_curr_qc_status NUMBER(2);

Line 2598: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence

2594: RAISE INVALID_QC_STATUS;
2595: END IF;
2596:
2597: IF p_sample_id IS NOT NULL THEN
2598: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence
2599: SELECT gs.organization_id ,
2600: gs.inventory_item_id,
2601: iim.concatenated_segments,
2602: gs.parent_lot_number,

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 2634: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence

2630:
2631:
2632:
2633: ELSE
2634: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence
2635: SELECT gse.organization_id,
2636: gse.inventory_item_id,
2637: iim.concatenated_segments,
2638: gse.parent_lot_number,

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 3754: mtl_system_items_b m,

3750:
3751: CURSOR c_order_line IS
3752: SELECT 1
3753: FROM oe_order_lines_all l,
3754: mtl_system_items_b m,
3755: mtl_parameters mp,
3756: ic_item_mst i
3757: WHERE l.header_id = p_sample.order_id
3758: AND l.line_id = p_sample.order_line_id

Line 3793: FROM mtl_system_items_b msi

3789: WHERE l.po_header_id = p_sample.po_header_id
3790: AND l.po_line_id = p_sample.po_line_id
3791: AND EXISTS
3792: (SELECT 1
3793: FROM mtl_system_items_b msi
3794: WHERE msi.inventory_item_id = l.item_id
3795: AND msi.inventory_item_id = p_sample.inventory_item_id) ;
3796:
3797: -- 7027149

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 5076: FROM mtl_system_items_kfv

5072: WHERE item_id = item_id;
5073: */
5074: CURSOR C_item_no(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
5075: SELECT concatenated_segments item_number
5076: FROM mtl_system_items_kfv
5077: WHERE inventory_item_id = p_inventory_item_id
5078: AND organization_id = p_organization_id;
5079:
5080:

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

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: