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

1251: , p_operation IN VARCHAR2
1252: , x_return_status OUT NOCOPY VARCHAR2
1253: ) IS
1254:
1255: Cursor fetch_mtl_system_items IS
1256: SELECT primary_uom_code
1257: FROM mtl_system_items_b
1258: WHERE inventory_item_id = p_sample.inventory_item_id
1259: AND organization_id = p_sample.organization_id;

Line 1257: FROM mtl_system_items_b

1253: ) IS
1254:
1255: Cursor fetch_mtl_system_items IS
1256: SELECT primary_uom_code
1257: FROM mtl_system_items_b
1258: WHERE inventory_item_id = p_sample.inventory_item_id
1259: AND organization_id = p_sample.organization_id;
1260:
1261: -- Local Variables

Line 1265: --l_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;

1261: -- Local Variables
1262: l_return_status VARCHAR2(1);
1263: dummy NUMBER;
1264:
1265: --l_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;
1266: --l_in_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;
1267: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1268: l_primary_uom_code VARCHAR2(3);
1269: from_name VARCHAR2(50);

Line 1266: --l_in_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;

1262: l_return_status VARCHAR2(1);
1263: dummy NUMBER;
1264:
1265: --l_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;
1266: --l_in_item_mst MTL_SYSTEM_ITEMS_B_KFV%ROWTYPE;
1267: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1268: l_primary_uom_code VARCHAR2(3);
1269: from_name VARCHAR2(50);
1270: to_name VARCHAR2(50);

Line 1358: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst

1354: END IF;
1355:
1356: -- Sample Quantity UOM must be convertible to Item's UOM
1357: IF p_sample.sample_type = 'I' THEN
1358: -- Bug 4165704: got primary uom from mtl_system_items instead of ic_item_mst
1359: --l_in_item_mst.inventory_item_id := p_sample.inventory_item_id;
1360: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN
1361: -- RAISE e_error_fetch_item;
1362: --END IF;

Line 1364: OPEN fetch_mtl_system_items;

1360: --IF NOT gmivdbl.ic_item_mst_select (l_in_item_mst, l_item_mst) THEN
1361: -- RAISE e_error_fetch_item;
1362: --END IF;
1363:
1364: OPEN fetch_mtl_system_items;
1365: FETCH fetch_mtl_system_items into l_primary_uom_code;
1366: CLOSE fetch_mtl_system_items;
1367: END IF;
1368:

Line 1365: FETCH fetch_mtl_system_items into l_primary_uom_code;

1361: -- RAISE e_error_fetch_item;
1362: --END IF;
1363:
1364: OPEN fetch_mtl_system_items;
1365: FETCH fetch_mtl_system_items into l_primary_uom_code;
1366: CLOSE fetch_mtl_system_items;
1367: END IF;
1368:
1369: BEGIN

Line 1366: CLOSE fetch_mtl_system_items;

1362: --END IF;
1363:
1364: OPEN fetch_mtl_system_items;
1365: FETCH fetch_mtl_system_items into l_primary_uom_code;
1366: CLOSE fetch_mtl_system_items;
1367: END IF;
1368:
1369: BEGIN
1370: -- UOM conversion is only needed for Material samples

Line 2221: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;

2217: l_data VARCHAR2(2000);
2218: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
2219: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;
2220: l_inventory_item_number VARCHAR2(2000);
2221: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
2222: l_organization_id NUMBER;
2223: l_batch_id NUMBER(15);
2224: l_step_no NUMBER(10);
2225: l_curr_qc_status NUMBER(2);

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

2347: RAISE INVALID_QC_STATUS;
2348: END IF;
2349:
2350: IF p_sample_id IS NOT NULL THEN
2351: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence
2352: SELECT gs.organization_id ,
2353: gs.inventory_item_id,
2354: iim.concatenated_segments,
2355: gs.parent_lot_number,

Line 2371: MTL_SYSTEM_ITEMS_b_kfv iim

2367: l_step_no,
2368: l_locator_id, -- 50061731
2369: l_subinventory -- 50061731
2370: FROM GMD_SAMPLES gs,
2371: MTL_SYSTEM_ITEMS_b_kfv iim
2372: WHERE gs.sample_id = p_sample_id
2373: AND gs.inventory_item_id = iim.inventory_item_id
2374: AND gs.organization_id = iim.organization_id;
2375: ELSE

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

2372: WHERE gs.sample_id = p_sample_id
2373: AND gs.inventory_item_id = iim.inventory_item_id
2374: AND gs.organization_id = iim.organization_id;
2375: ELSE
2376: -- BUG 4165704: changed ic_item_mst to mtl_system_items, and updated field names for inventory convergence
2377: SELECT gse.organization_id,
2378: gse.inventory_item_id,
2379: iim.concatenated_segments,
2380: gse.parent_lot_number,

Line 2396: MTL_SYSTEM_ITEMS_b_kfv iim

2392: l_step_no
2393: FROM GMD_COMPOSITE_SPEC_DISP csd,
2394: GMD_EVENT_SPEC_DISP esd ,
2395: GMD_SAMPLING_EVENTS gse,
2396: MTL_SYSTEM_ITEMS_b_kfv iim
2397: WHERE csd.composite_spec_disp_id = p_composite_spec_disp_id
2398: and csd.event_spec_disp_id = esd.event_spec_disp_id
2399: and esd.sampling_event_id = gse.sampling_event_id
2400: and gse.inventory_item_id = iim.inventory_item_id

Line 3007: FROM mtl_system_items_b_kfv

3003:
3004: -- Bug 4165704: changed for inventory convergence
3005: CURSOR c_item(p_inventory_item_id NUMBER, p_organization_id NUMBER) IS
3006: SELECT 1
3007: FROM mtl_system_items_b_kfv
3008: WHERE organization_id = p_organization_id
3009: AND process_quality_enabled_flag = 'Y'
3010: AND inventory_item_id = p_inventory_item_id;
3011:

Line 3159: mtl_system_items_b m,

3155:
3156: CURSOR c_order_line IS
3157: SELECT 1
3158: FROM oe_order_lines_all l,
3159: mtl_system_items_b m,
3160: mtl_parameters mp,
3161: ic_item_mst i
3162: WHERE l.header_id = p_sample.order_id
3163: AND l.line_id = p_sample.order_line_id

Line 3198: FROM mtl_system_items_b msi

3194: WHERE l.po_header_id = p_sample.po_header_id
3195: AND l.po_line_id = p_sample.po_line_id
3196: AND EXISTS
3197: (SELECT 1
3198: FROM mtl_system_items_b msi
3199: WHERE msi.inventory_item_id = l.item_id
3200: AND msi.inventory_item_id = p_sample.inventory_item_id) ;
3201:
3202: dummy NUMBER;

Line 4025: FROM mtl_system_items_b_kfv

4021: SELECT concatenated_segments item_no ,
4022: dual_uom_control,
4023: primary_uom_code,
4024: secondary_uom_code
4025: FROM mtl_system_items_b_kfv
4026: WHERE inventory_item_id = p_item_id
4027: AND organization_id = p_sample.organization_id;
4028:
4029: -- bug 4165704: following added for new GME proc

Line 4431: FROM mtl_system_items_kfv

4427: WHERE item_id = item_id;
4428: */
4429: CURSOR C_item_no(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
4430: SELECT concatenated_segments item_number
4431: FROM mtl_system_items_kfv
4432: WHERE inventory_item_id = p_inventory_item_id
4433: AND organization_id = p_organization_id;
4434:
4435:

Line 4970: FROM mtl_system_items_b_kfv

4966: Indivisible_flag,
4967: Serial_number_control_code, --(must = 0 to generate inv transaction)
4968: process_yield_subinventory, -- replenish subinventory
4969: process_yield_locator_id -- replenish locator_id
4970: FROM mtl_system_items_b_kfv
4971: WHERE organization_id = p_sample_display.organization_id
4972: AND inventory_item_id = p_sample_display.inventory_item_id;
4973:
4974: