DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 251: FROM mtl_system_items_kfv

247: lot_control_code,
248: concatenated_segments,
249: revision_qty_control_code,
250: comms_nl_trackable_flag
251: FROM mtl_system_items_kfv
252: WHERE inventory_item_id = c_inventory_id
253: AND organization_id = c_organization_id;
254: l_serial_number_control NUMBER;
255: l_lot_control_code NUMBER;

Line 257: -- Changed from 40 to mtl_system_items_kfv.concatenated_segments%TYPE in order

253: AND organization_id = c_organization_id;
254: l_serial_number_control NUMBER;
255: l_lot_control_code NUMBER;
256: -- Changed by jaramana on 16-APR-2008 for bug 6977832
257: -- Changed from 40 to mtl_system_items_kfv.concatenated_segments%TYPE in order
258: -- to accommodate longer item names.
259: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
260: l_revision_qty_control_code NUMBER;
261: l_comms_nl_trackable_flag VARCHAR2(1);

Line 259: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

255: l_lot_control_code NUMBER;
256: -- Changed by jaramana on 16-APR-2008 for bug 6977832
257: -- Changed from 40 to mtl_system_items_kfv.concatenated_segments%TYPE in order
258: -- to accommodate longer item names.
259: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
260: l_revision_qty_control_code NUMBER;
261: l_comms_nl_trackable_flag VARCHAR2(1);
262: BEGIN
263: IF (p_inventory_id IS NULL) OR (p_inventory_id = FND_API.G_MISS_NUM)

Line 336: mtl_system_items_kfv m,

332: -- SATHAPLI::Bug#4912576 fix::SQL ID 14401150 --
333: /*
334: SELECT o.operating_unit
335: FROM org_organization_definitions o,
336: mtl_system_items_kfv m,
337: csi_item_instances c
338: WHERE c.instance_id = p_instance_id
339: AND c.inventory_item_id = m.inventory_item_id
340: AND c.inv_master_organization_id = m.organization_id

Line 344: FROM inv_organization_info_v i, mtl_system_items_kfv m,

340: AND c.inv_master_organization_id = m.organization_id
341: AND m.organization_id = o.organization_id;
342: */
343: SELECT i.operating_unit
344: FROM inv_organization_info_v i, mtl_system_items_kfv m,
345: csi_item_instances c
346: WHERE c.instance_id = p_instance_id AND
347: c.inventory_item_id = m.inventory_item_id AND
348: c.inv_master_organization_id = m.organization_id AND

Line 1319: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

1315: l_sn_tag_rec_found VARCHAR2(1) DEFAULT 'Y';
1316: l_serial_number_control NUMBER;
1317: l_mfg_date csi_iea_values.attribute_value%TYPE;
1318: l_mfg_date_rec_found VARCHAR2(1) DEFAULT 'Y';
1319: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
1320: l_lookup_code fnd_lookups.lookup_code%TYPE;
1321: l_item_assoc_id NUMBER;
1322: l_end_date DATE;
1323:

Line 2275: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

2271: l_attribute_value_id NUMBER;
2272: l_attribute_value csi_iea_values.attribute_value%TYPE;
2273: l_attribute_id NUMBER;
2274: l_subscript NUMBER DEFAULT 0;
2275: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
2276: l_item_assoc_id NUMBER;
2277: l_new_instance_id NUMBER;
2278: l_new_csi_instance_ovn NUMBER;
2279: l_parent_uc_header_id NUMBER;

Line 3328: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

3324: l_dummy_char VARCHAR2(1);
3325: l_subunit BOOLEAN;
3326: i NUMBER := 0;
3327: l_subscript NUMBER DEFAULT 0;
3328: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
3329: l_item_assoc_id NUMBER;
3330: l_meaning fnd_lookups.meaning%TYPE;
3331: l_parent_uc_header_id NUMBER;
3332: l_parent_instance_id NUMBER;

Line 4648: mtl_system_items_kfv M,

4644: C.inv_subinventory_name,
4645: C.inv_locator_id,
4646: to_number(NULL) uc_header_id
4647: FROM csi_item_instances C,
4648: mtl_system_items_kfv M,
4649: ahl_mc_relationships R,
4650: ahl_item_associations_b A
4651: WHERE C.inventory_item_id = M.inventory_item_id
4652: AND C.inv_master_organization_id = M.organization_id

Line 4763: mtl_system_items_kfv M

4759: C.inv_locator_id,
4760: U.uc_header_id uc_header_id
4761: FROM ahl_unit_config_headers_v U,
4762: csi_item_instances C,
4763: mtl_system_items_kfv M
4764: WHERE U.csi_instance_id = C.instance_id
4765: AND C.inventory_item_id = M.inventory_item_id
4766: AND C.inv_master_organization_id = M.organization_id
4767: AND trunc(nvl(U.active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 5350: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE :=upper(nvl(p_item_number, '%'));

5346: l_inventory_revision VARCHAR2(3);
5347: l_uom_code VARCHAR2(3);
5348: l_item_assoc_id NUMBER;
5349: l_priority NUMBER;
5350: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE :=upper(nvl(p_item_number, '%'));
5351: l_serial_number csi_item_instances.serial_number%TYPE := upper(nvl(p_serial_number, '%'));
5352: l_uc_header_id NUMBER;
5353: i NUMBER;
5354: j NUMBER;

Line 5392: mtl_system_items_kfv M,

5388: C.inventory_revision,
5389: C.unit_of_measure uom_code,
5390: to_number(NULL) uc_header_id
5391: FROM csi_item_instances C,
5392: mtl_system_items_kfv M,
5393: ahl_mc_relationships R,
5394: ahl_item_associations_b A
5395: WHERE C.inventory_item_id = M.inventory_item_id
5396: AND C.inv_master_organization_id = M.organization_id

Line 5508: mtl_system_items_kfv M

5504: trunc(nvl(CR.active_start_date (+), SYSDATE)) <= trunc(SYSDATE) AND
5505: trunc(nvl(CR.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE)
5506: ) U,
5507: csi_item_instances C,
5508: mtl_system_items_kfv M
5509: WHERE U.csi_instance_id = C.instance_id
5510: AND C.inventory_item_id = M.inventory_item_id
5511: AND C.inv_master_organization_id = M.organization_id
5512: AND trunc(nvl(U.active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 6151: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

6147: i NUMBER := 0;
6148: l_transaction_type_id NUMBER;
6149: l_return_val BOOLEAN;
6150: l_attribute_id NUMBER;
6151: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
6152: l_new_instance_id NUMBER;
6153: l_new_csi_instance_ovn NUMBER;
6154: l_end_date DATE;
6155: