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.AHL_UMP_UF_PVT dependencies on AHL_UF_HEADERS

Line 288: AHL_UF_HEADERS_PKG.insert_row(

284: p_x_uf_header_rec.last_updated_by := fnd_global.user_id;
285: p_x_uf_header_rec.last_update_date := SYSDATE;
286: p_x_uf_header_rec.last_update_login := fnd_global.user_id;
287:
288: AHL_UF_HEADERS_PKG.insert_row(
289: x_uf_header_id => p_x_uf_header_rec.uf_header_id,
290: x_object_version_number => p_x_uf_header_rec.object_version_number,
291: x_created_by => p_x_uf_header_rec.created_by,
292: x_creation_date => p_x_uf_header_rec.creation_date,

Line 328: AHL_UF_HEADERS_PKG.update_row(

324: p_x_uf_header_rec.last_updated_by := fnd_global.user_id;
325: p_x_uf_header_rec.last_update_date := SYSDATE;
326: p_x_uf_header_rec.last_update_login := fnd_global.user_id;
327:
328: AHL_UF_HEADERS_PKG.update_row(
329: x_uf_header_id => p_x_uf_header_rec.uf_header_id,
330: x_object_version_number => p_x_uf_header_rec.object_version_number,
331: x_last_updated_by => p_x_uf_header_rec.last_updated_by,
332: x_last_update_date => p_x_uf_header_rec.last_update_date,

Line 403: FROM ahl_uf_headers

399: WHERE name = p_unit_name;
400:
401: CURSOR uf_header_id_uid_csr(p_unit_config_header_id IN NUMBER) IS
402: SELECT uf_header_id
403: FROM ahl_uf_headers
404: WHERE unit_config_header_id = p_unit_config_header_id;
405:
406: BEGIN
407:

Line 458: FROM ahl_uf_headers

454:
455:
456: CURSOR uf_header_id_pid_csr(p_inventory_item_id IN NUMBER) IS
457: SELECT uf_header_id
458: FROM ahl_uf_headers
459: WHERE inventory_item_id = p_inventory_item_id;
460:
461:
462: BEGIN

Line 503: FROM ahl_uf_headers

499: )IS
500:
501: CURSOR uf_header_id_nid_csr(p_pc_node_id IN NUMBER) IS
502: SELECT uf_header_id
503: FROM ahl_uf_headers
504: WHERE pc_node_id = p_pc_node_id;
505:
506: l_uf_header_id NUMBER;
507:

Line 555: FROM ahl_uf_headers

551: ) IS
552:
553: CURSOR uf_header_csr (p_uf_header_id IN NUMBER) IS
554: SELECT object_version_number, unit_config_header_id,pc_node_id,inventory_item_id,inventory_org_id,use_unit_flag
555: FROM ahl_uf_headers
556: WHERE uf_header_id = p_uf_header_id;
557:
558:
559: l_object_version_number NUMBER;

Line 564: l_use_unit_flag ahl_uf_headers.use_unit_flag%TYPE;

560: l_unit_config_header_id NUMBER;
561: l_pc_node_id NUMBER;
562: l_inventory_item_id NUMBER;
563: l_inventory_org_id NUMBER;
564: l_use_unit_flag ahl_uf_headers.use_unit_flag%TYPE;
565:
566: CURSOR unit_status_check_csr(p_unit_config_header_id IN NUMBER) IS
567: SELECT UCH.unit_config_status_code
568: FROM ahl_unit_config_headers UCH

Line 839: FROM ahl_uf_headers

835: ) IS
836:
837: CURSOR uf_header_csr (p_uf_header_id IN NUMBER) IS
838: SELECT object_version_number, inventory_item_id,csi_item_instance_id,use_unit_flag
839: FROM ahl_uf_headers
840: WHERE uf_header_id = p_uf_header_id;
841:
842:
843: l_object_version_number NUMBER;

Line 846: l_use_unit_flag ahl_uf_headers.use_unit_flag%TYPE;

842:
843: l_object_version_number NUMBER;
844: l_inventory_item_id NUMBER;
845: l_csi_item_instance_id NUMBER;
846: l_use_unit_flag ahl_uf_headers.use_unit_flag%TYPE;
847:
848: --l_part_number mtl_system_items_kfv.concatenated_segments%TYPE;
849:
850: CURSOR part_check_csr(p_inventory_item_id IN NUMBER) IS

Line 1003: FROM ahl_uf_headers

999: SELECT unit_config_header_id, inventory_item_id, pc_node_id, inventory_org_id,csi_item_instance_id,
1000: use_unit_flag, attribute_category, attribute1,attribute2, attribute3,
1001: attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,
1002: attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
1003: FROM ahl_uf_headers
1004: WHERE object_version_number= p_object_version_number
1005: AND uf_header_id = p_uf_header_id;
1006:
1007: l_uf_header_rec AHL_UMP_UF_PVT.uf_header_Rec_type;

Line 1932: AHL_UF_HEADERS_PKG.delete_row(p_uf_header_rec.uf_header_id);

1928: IF(p_uf_header_rec.use_unit_flag IS NULL OR p_uf_header_rec.use_unit_flag = G_UF_USE_UNIT_DEFAULT) THEN
1929: OPEN uf_details_csr (p_uf_header_rec.uf_header_id);
1930: FETCH uf_details_csr INTO l_exist;
1931: IF(uf_details_csr%NOTFOUND) THEN
1932: AHL_UF_HEADERS_PKG.delete_row(p_uf_header_rec.uf_header_id);
1933: END IF;
1934: CLOSE uf_details_csr;
1935: END IF;
1936: END post_process_uf_header;

Line 2006: FROM ahl_uf_details a, ahl_uf_headers b

2002: CONNECT BY pc_node_id = PRIOR parent_node_id;
2003: --
2004: CURSOR ahl_uf_uom_nodes_csr (c_pc_id IN NUMBER) IS
2005: SELECT distinct a.uom_code
2006: FROM ahl_uf_details a, ahl_uf_headers b
2007: WHERE a.uf_header_id = b.uf_header_id
2008: AND b.pc_node_id = c_pc_id;
2009: --
2010: CURSOR ahl_uf_details_csr (c_pc_id IN NUMBER, p_uom_code IN VARCHAR2) IS

Line 2039: FROM ahl_uf_details a, ahl_uf_headers b

2035: a.ATTRIBUTE12 ,
2036: a.ATTRIBUTE13 ,
2037: a.ATTRIBUTE14 ,
2038: a.ATTRIBUTE15
2039: FROM ahl_uf_details a, ahl_uf_headers b
2040: WHERE a.uom_code = p_uom_code
2041: AND b.pc_node_id = c_pc_id
2042: AND a.uf_header_id = b.uf_header_id;
2043: --

Line 2073: FROM ahl_uf_details a, ahl_uf_headers b

2069: a.ATTRIBUTE12 ,
2070: a.ATTRIBUTE13 ,
2071: a.ATTRIBUTE14 ,
2072: a.ATTRIBUTE15
2073: FROM ahl_uf_details a, ahl_uf_headers b
2074: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2075: AND a.uf_header_id = b.uf_header_id
2076: AND a.uom_code = p_uom_code
2077: AND b.pc_node_id = p_pc_id;

Line 2082: FROM ahl_uf_details a, ahl_uf_headers b

2078:
2079: -- added to fix bug# 6749351
2080: CURSOR ahl_uf_uom_item_csr (p_inventory_item_id IN NUMBER) IS
2081: SELECT distinct a.uom_code
2082: FROM ahl_uf_details a, ahl_uf_headers b
2083: WHERE a.uf_header_id = b.uf_header_id
2084: AND b.inventory_item_id = p_inventory_item_id;
2085:
2086: -- get uf details for item for all dates.

Line 2117: FROM ahl_uf_details a, ahl_uf_headers b

2113: a.ATTRIBUTE12 ,
2114: a.ATTRIBUTE13 ,
2115: a.ATTRIBUTE14 ,
2116: a.ATTRIBUTE15
2117: FROM ahl_uf_details a, ahl_uf_headers b
2118: WHERE a.uf_header_id = b.uf_header_id
2119: AND a.uom_code = p_uom_code
2120: AND b.inventory_item_id = p_inventory_item_id;
2121:

Line 2154: FROM ahl_uf_details a, ahl_uf_headers b

2150: a.ATTRIBUTE12 ,
2151: a.ATTRIBUTE13 ,
2152: a.ATTRIBUTE14 ,
2153: a.ATTRIBUTE15
2154: FROM ahl_uf_details a, ahl_uf_headers b
2155: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2156: AND a.uf_header_id = b.uf_header_id
2157: AND a.uom_code = p_uom_code
2158: AND b.inventory_item_id = p_inventory_item_id;

Line 2163: FROM ahl_uf_details a, ahl_uf_headers b

2159:
2160: -- added to fix bug# 6749351
2161: CURSOR ahl_uf_uom_unit_csr (p_unit_config_id IN NUMBER) IS
2162: SELECT distinct a.uom_code
2163: FROM ahl_uf_details a, ahl_uf_headers b
2164: WHERE a.uf_header_id = b.uf_header_id
2165: AND b.unit_config_header_id = p_unit_config_id;
2166:
2167: -- get uf details for item for all dates.

Line 2198: FROM ahl_uf_details a, ahl_uf_headers b

2194: a.ATTRIBUTE12 ,
2195: a.ATTRIBUTE13 ,
2196: a.ATTRIBUTE14 ,
2197: a.ATTRIBUTE15
2198: FROM ahl_uf_details a, ahl_uf_headers b
2199: WHERE a.uf_header_id = b.uf_header_id
2200: AND a.uom_code = p_uom_code
2201: AND b.unit_config_header_id = p_unit_config_id;
2202:

Line 2235: FROM ahl_uf_details a, ahl_uf_headers b

2231: a.ATTRIBUTE12 ,
2232: a.ATTRIBUTE13 ,
2233: a.ATTRIBUTE14 ,
2234: a.ATTRIBUTE15
2235: FROM ahl_uf_details a, ahl_uf_headers b
2236: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2237: AND a.uf_header_id = b.uf_header_id
2238: AND a.uom_code = p_uom_code
2239: AND b.unit_config_header_id = p_unit_config_id;

Line 2692: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c

2688: a.ATTRIBUTE12 ,
2689: a.ATTRIBUTE13 ,
2690: a.ATTRIBUTE14 ,
2691: a.ATTRIBUTE15
2692: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
2693: WHERE a.uf_header_id = b.uf_header_id
2694: AND b.inventory_item_id = c.inventory_item_id
2695: AND c.instance_id = p_csi_item_instance_id;
2696:

Line 2726: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c

2722: a.ATTRIBUTE12 ,
2723: a.ATTRIBUTE13 ,
2724: a.ATTRIBUTE14 ,
2725: a.ATTRIBUTE15
2726: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
2727: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2728: AND a.uf_header_id = b.uf_header_id
2729: AND b.inventory_item_id = c.inventory_item_id
2730: AND c.instance_id = p_csi_item_instance_id;