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.

[Home] [Help]

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: -- JKJain, NR Analysis and Forecasting
2010: order by uom_code;

Line 2041: FROM ahl_uf_details a, ahl_uf_headers b

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

Line 2075: FROM ahl_uf_details a, ahl_uf_headers b

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

Line 2084: FROM ahl_uf_details a, ahl_uf_headers b

2080:
2081: -- added to fix bug# 6749351
2082: CURSOR ahl_uf_uom_item_csr (p_inventory_item_id IN NUMBER) IS
2083: SELECT distinct a.uom_code
2084: FROM ahl_uf_details a, ahl_uf_headers b
2085: WHERE a.uf_header_id = b.uf_header_id
2086: AND b.inventory_item_id = p_inventory_item_id
2087: -- JKJain, NR Analysis and Forecasting
2088: order by uom_code;

Line 2121: FROM ahl_uf_details a, ahl_uf_headers b

2117: a.ATTRIBUTE12 ,
2118: a.ATTRIBUTE13 ,
2119: a.ATTRIBUTE14 ,
2120: a.ATTRIBUTE15
2121: FROM ahl_uf_details a, ahl_uf_headers b
2122: WHERE a.uf_header_id = b.uf_header_id
2123: AND a.uom_code = p_uom_code
2124: AND b.inventory_item_id = p_inventory_item_id;
2125:

Line 2158: FROM ahl_uf_details a, ahl_uf_headers b

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

Line 2167: FROM ahl_uf_details a, ahl_uf_headers b

2163:
2164: -- added to fix bug# 6749351
2165: CURSOR ahl_uf_uom_unit_csr (p_unit_config_id IN NUMBER) IS
2166: SELECT distinct a.uom_code
2167: FROM ahl_uf_details a, ahl_uf_headers b
2168: WHERE a.uf_header_id = b.uf_header_id
2169: AND b.unit_config_header_id = p_unit_config_id
2170: order by uom_code;
2171:

Line 2203: FROM ahl_uf_details a, ahl_uf_headers b

2199: a.ATTRIBUTE12 ,
2200: a.ATTRIBUTE13 ,
2201: a.ATTRIBUTE14 ,
2202: a.ATTRIBUTE15
2203: FROM ahl_uf_details a, ahl_uf_headers b
2204: WHERE a.uf_header_id = b.uf_header_id
2205: AND a.uom_code = p_uom_code
2206: AND b.unit_config_header_id = p_unit_config_id;
2207:

Line 2240: FROM ahl_uf_details a, ahl_uf_headers b

2236: a.ATTRIBUTE12 ,
2237: a.ATTRIBUTE13 ,
2238: a.ATTRIBUTE14 ,
2239: a.ATTRIBUTE15
2240: FROM ahl_uf_details a, ahl_uf_headers b
2241: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2242: AND a.uf_header_id = b.uf_header_id
2243: AND a.uom_code = p_uom_code
2244: AND b.unit_config_header_id = p_unit_config_id;

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

2693: a.ATTRIBUTE12 ,
2694: a.ATTRIBUTE13 ,
2695: a.ATTRIBUTE14 ,
2696: a.ATTRIBUTE15
2697: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
2698: WHERE a.uf_header_id = b.uf_header_id
2699: AND b.inventory_item_id = c.inventory_item_id
2700: AND c.instance_id = p_csi_item_instance_id;
2701:

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

2727: a.ATTRIBUTE12 ,
2728: a.ATTRIBUTE13 ,
2729: a.ATTRIBUTE14 ,
2730: a.ATTRIBUTE15
2731: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
2732: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2733: AND a.uf_header_id = b.uf_header_id
2734: AND b.inventory_item_id = c.inventory_item_id
2735: AND c.instance_id = p_csi_item_instance_id;