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_UTIL_UC_PKG dependencies on CSI_ITEM_INSTANCES

Line 511: FROM csi_item_instances csi

507:
508: -- For validation of csi_item_instance.
509: CURSOR csi_item_instance_csr(p_csi_item_instance_id IN NUMBER) IS
510: SELECT instance_status_id, location_type_code
511: FROM csi_item_instances csi
512: WHERE csi.instance_id = p_csi_item_instance_id;
513:
514: CURSOR csi_inst_statuses_csr(p_instance_status_id IN NUMBER) IS
515: SELECT name

Line 523: l_location_type_code csi_item_instances.location_type_code%TYPE;

519: l_return_val BOOLEAN DEFAULT TRUE;
520: l_status_name csi_instance_statuses.name%TYPE DEFAULT NULL;
521: l_status_id NUMBER;
522:
523: l_location_type_code csi_item_instances.location_type_code%TYPE;
524:
525: BEGIN
526:
527: OPEN csi_item_instance_csr(p_instance_id);

Line 1015: FROM csi_item_instances csi

1011: -- Cursor to read instance details.
1012: CURSOR csi_item_instance_csr (p_csi_item_instance_id IN NUMBER) IS
1013: SELECT inventory_item_id, last_vld_organization_id, quantity, unit_of_measure,
1014: inventory_revision, instance_number
1015: FROM csi_item_instances csi
1016: WHERE instance_id = p_csi_item_instance_id;
1017:
1018: -- Cursor to get position ref code.
1019: CURSOR ahl_relationships_csr1 (p_mc_relationship_id IN NUMBER) IS

Line 1057: l_inventory_revision csi_item_instances.inventory_revision%TYPE;

1053:
1054: l_Inventory_item_id NUMBER;
1055: l_inventory_org_id NUMBER;
1056: l_quantity NUMBER;
1057: l_inventory_revision csi_item_instances.inventory_revision%TYPE;
1058: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1059: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1060: l_item_assoc_id NUMBER;
1061: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;

Line 1058: l_uom_code csi_item_instances.unit_of_measure%TYPE;

1054: l_Inventory_item_id NUMBER;
1055: l_inventory_org_id NUMBER;
1056: l_quantity NUMBER;
1057: l_inventory_revision csi_item_instances.inventory_revision%TYPE;
1058: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1059: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1060: l_item_assoc_id NUMBER;
1061: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;
1062: l_instance_number csi_item_instances.instance_number%TYPE;

Line 1062: l_instance_number csi_item_instances.instance_number%TYPE;

1058: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1059: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1060: l_item_assoc_id NUMBER;
1061: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;
1062: l_instance_number csi_item_instances.instance_number%TYPE;
1063:
1064: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON'),'N');
1065: l_debug VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
1066:

Line 1337: FROM csi_ii_relationships reln, csi_item_instances csi

1333: CURSOR get_item_instances_csr(c_position_reference IN VARCHAR2,
1334: c_inventory_item_id IN NUMBER,
1335: c_inventory_org_id IN NUMBER) IS
1336: SELECT instance_id csi_item_instance_id, csi.object_version_number
1337: FROM csi_ii_relationships reln, csi_item_instances csi
1338: WHERE reln.subject_id = csi.instance_id
1339: AND TRUNC(SYSDATE) < TRUNC(NVL(reln.active_end_date, SYSDATE+1))
1340: AND trunc(nvl(reln.active_start_date,sysdate-1)) < trunc(sysdate)
1341: AND reln.relationship_type_code = 'COMPONENT-OF'

Line 1351: FROM ahl_unit_config_headers uc, csi_item_instances csi, ahl_mc_relationships mc

1347: CURSOR chk_top_node_csr(c_relationship_id IN NUMBER,
1348: c_inventory_item_id IN NUMBER,
1349: c_inventory_org_id IN NUMBER) IS
1350: SELECT uc.csi_item_instance_id, uc.unit_config_header_id, uc.parent_uc_header_id, uc.unit_config_status_code
1351: FROM ahl_unit_config_headers uc, csi_item_instances csi, ahl_mc_relationships mc
1352: WHERE uc.csi_item_instance_id = csi.instance_id
1353: AND uc.master_config_id = mc.mc_header_id
1354: AND mc.relationship_id = c_relationship_id
1355: AND TRUNC(SYSDATE) < TRUNC(NVL(uc.active_end_date, SYSDATE+1))

Line 1648: CSI_ITEM_INSTANCES CSI

1644: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1645: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1646: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1647: FND_LOOKUP_VALUES_VL FL, FND_LOOKUP_VALUES_VL FLA,
1648: CSI_ITEM_INSTANCES CSI
1649: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1650: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1651: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
1652: FL.lookup_type = 'AHL_CONFIG_STATUS' AND

Line 1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

1665: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1672: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1673: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

Line 1674: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1672: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1673: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1674: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1675: l_return_value VARCHAR2(100) := null;
1676: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status';
1677:
1678: BEGIN

Line 1733: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC

1729: l_uc_active_status,
1730: l_uc_end_date,
1731: l_uc_inst_end_date
1732: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1733: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1734: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1735: AND UC.csi_item_instance_id = CSI.instance_id
1736: AND UC.unit_config_status_code = UCSC.lookup_code
1737: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 1762: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC

1758: l_root_active_status,
1759: l_root_end_date,
1760: l_root_inst_end_date
1761: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1762: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1763: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1764: AND UC.csi_item_instance_id = CSI.instance_id
1765: AND UC.unit_config_status_code = UCSC.lookup_code
1766: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 1844: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL

1840: FL.meaning,
1841: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1842: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1843: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1844: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL
1845: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1846: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1847: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
1848: ROOT_UC.UNIT_CONFIG_STATUS_CODE = FL.LOOKUP_CODE AND

Line 1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

1852: l_root_uc_header_id NUMBER;
1853: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1854: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1855: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1858: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1859: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1860: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

Line 1860: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1858: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1859: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1860: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1861: l_return_value VARCHAR2(100) := null;
1862: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status_code';
1863:
1864: BEGIN

Line 1916: CSI_ITEM_INSTANCES CSI

1912: l_uc_status,
1913: l_uc_end_date,
1914: l_uc_inst_end_date
1915: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1916: CSI_ITEM_INSTANCES CSI
1917: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1918: AND UC.csi_item_instance_id = CSI.instance_id
1919: AND UC.unit_config_status_code = UCSC.lookup_code
1920: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 1940: CSI_ITEM_INSTANCES CSI

1936: l_root_status,
1937: l_root_end_date,
1938: l_root_inst_end_date
1939: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1940: CSI_ITEM_INSTANCES CSI
1941: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1942: AND UC.csi_item_instance_id = CSI.instance_id
1943: AND UC.unit_config_status_code = UCSC.lookup_code
1944: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 2651: FROM CSI_II_RELATIONSHIPS RELN, CSI_ITEM_INSTANCES CSI

2647: CURSOR c_get_item_instances_csr(c_position_reference VARCHAR2,
2648: c_inventory_item_id NUMBER,
2649: c_inventory_org_id NUMBER) IS
2650: SELECT CSI.instance_id
2651: FROM CSI_II_RELATIONSHIPS RELN, CSI_ITEM_INSTANCES CSI
2652: WHERE RELN.subject_id = CSI.instance_id AND
2653: RELN.relationship_type_code = 'COMPONENT-OF' AND
2654: RELN.position_reference = c_position_reference AND
2655: CSI.inventory_item_id = c_inventory_item_id AND

Line 2666: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI,

2662: c_inventory_item_id NUMBER,
2663: c_inventory_org_id NUMBER) IS
2664: SELECT UC.name,
2665: UC.unit_config_header_id
2666: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI,
2667: AHL_MC_RELATIONSHIPS MC
2668: WHERE UC.csi_item_instance_id = CSI.instance_id AND
2669: UC.master_config_id = MC.mc_header_id AND
2670: UC.parent_uc_header_id IS NULL AND

Line 2683: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI

2679: -- Get UC header info
2680: CURSOR c_get_uc_header_info_csr(p_csi_item_instance_id NUMBER) IS
2681: SELECT UC.name,
2682: UC.unit_config_header_id
2683: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI
2684: WHERE UC.csi_item_instance_id IN
2685: (SELECT object_id
2686: FROM CSI_II_RELATIONSHIPS
2687: START WITH