APPS.GMD_SAMPLES_GRP dependencies on MTL_SYSTEM_ITEMS_B

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