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 506: FROM csi_item_instances csi

502:
503: -- For validation of csi_item_instance.
504: CURSOR csi_item_instance_csr(p_csi_item_instance_id IN NUMBER) IS
505: SELECT instance_status_id, location_type_code
506: FROM csi_item_instances csi
507: WHERE csi.instance_id = p_csi_item_instance_id;
508:
509: CURSOR csi_inst_statuses_csr(p_instance_status_id IN NUMBER) IS
510: SELECT name

Line 518: l_location_type_code csi_item_instances.location_type_code%TYPE;

514: l_return_val BOOLEAN DEFAULT TRUE;
515: l_status_name csi_instance_statuses.name%TYPE DEFAULT NULL;
516: l_status_id NUMBER;
517:
518: l_location_type_code csi_item_instances.location_type_code%TYPE;
519:
520: BEGIN
521:
522: OPEN csi_item_instance_csr(p_instance_id);

Line 1010: FROM csi_item_instances csi

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

Line 1052: l_inventory_revision csi_item_instances.inventory_revision%TYPE;

1048:
1049: l_Inventory_item_id NUMBER;
1050: l_inventory_org_id NUMBER;
1051: l_quantity NUMBER;
1052: l_inventory_revision csi_item_instances.inventory_revision%TYPE;
1053: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1054: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1055: l_item_assoc_id NUMBER;
1056: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;

Line 1053: l_uom_code csi_item_instances.unit_of_measure%TYPE;

1049: l_Inventory_item_id NUMBER;
1050: l_inventory_org_id NUMBER;
1051: l_quantity NUMBER;
1052: l_inventory_revision csi_item_instances.inventory_revision%TYPE;
1053: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1054: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1055: l_item_assoc_id NUMBER;
1056: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;
1057: l_instance_number csi_item_instances.instance_number%TYPE;

Line 1057: l_instance_number csi_item_instances.instance_number%TYPE;

1053: l_uom_code csi_item_instances.unit_of_measure%TYPE;
1054: l_position_ref_meaning FND_LOOKUPS.meaning%TYPE;
1055: l_item_assoc_id NUMBER;
1056: l_part_posn_ref_code FND_LOOKUPS.lookup_code%TYPE;
1057: l_instance_number csi_item_instances.instance_number%TYPE;
1058:
1059: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON'),'N');
1060: l_debug VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
1061:

Line 1332: FROM csi_ii_relationships reln, csi_item_instances csi

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

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

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

Line 1643: CSI_ITEM_INSTANCES CSI

1639: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1640: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1641: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1642: FND_LOOKUP_VALUES_VL FL, FND_LOOKUP_VALUES_VL FLA,
1643: CSI_ITEM_INSTANCES CSI
1644: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1645: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1646: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
1647: FL.lookup_type = 'AHL_CONFIG_STATUS' AND

Line 1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

1660: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1661: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1662: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

Line 1669: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_return_value VARCHAR2(100) := null;
1671: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status';
1672:
1673: BEGIN

Line 1728: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC

1724: l_uc_active_status,
1725: l_uc_end_date,
1726: l_uc_inst_end_date
1727: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1728: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1729: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1730: AND UC.csi_item_instance_id = CSI.instance_id
1731: AND UC.unit_config_status_code = UCSC.lookup_code
1732: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 1757: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC

1753: l_root_active_status,
1754: l_root_end_date,
1755: l_root_inst_end_date
1756: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1757: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1758: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1759: AND UC.csi_item_instance_id = CSI.instance_id
1760: AND UC.unit_config_status_code = UCSC.lookup_code
1761: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 1839: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL

1835: FL.meaning,
1836: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1837: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1838: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1839: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL
1840: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1841: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1842: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
1843: ROOT_UC.UNIT_CONFIG_STATUS_CODE = FL.LOOKUP_CODE AND

Line 1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

1847: l_root_uc_header_id NUMBER;
1848: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1849: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1850: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1853: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1854: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1855: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

Line 1855: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1853: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1854: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1855: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1856: l_return_value VARCHAR2(100) := null;
1857: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status_code';
1858:
1859: BEGIN

Line 1911: CSI_ITEM_INSTANCES CSI

1907: l_uc_status,
1908: l_uc_end_date,
1909: l_uc_inst_end_date
1910: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1911: CSI_ITEM_INSTANCES CSI
1912: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1913: AND UC.csi_item_instance_id = CSI.instance_id
1914: AND UC.unit_config_status_code = UCSC.lookup_code
1915: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 1935: CSI_ITEM_INSTANCES CSI

1931: l_root_status,
1932: l_root_end_date,
1933: l_root_inst_end_date
1934: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1935: CSI_ITEM_INSTANCES CSI
1936: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1937: AND UC.csi_item_instance_id = CSI.instance_id
1938: AND UC.unit_config_status_code = UCSC.lookup_code
1939: AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type

Line 2646: FROM CSI_II_RELATIONSHIPS RELN, CSI_ITEM_INSTANCES CSI

2642: CURSOR c_get_item_instances_csr(c_position_reference VARCHAR2,
2643: c_inventory_item_id NUMBER,
2644: c_inventory_org_id NUMBER) IS
2645: SELECT CSI.instance_id
2646: FROM CSI_II_RELATIONSHIPS RELN, CSI_ITEM_INSTANCES CSI
2647: WHERE RELN.subject_id = CSI.instance_id AND
2648: RELN.relationship_type_code = 'COMPONENT-OF' AND
2649: RELN.position_reference = c_position_reference AND
2650: CSI.inventory_item_id = c_inventory_item_id AND

Line 2661: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI,

2657: c_inventory_item_id NUMBER,
2658: c_inventory_org_id NUMBER) IS
2659: SELECT UC.name,
2660: UC.unit_config_header_id
2661: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI,
2662: AHL_MC_RELATIONSHIPS MC
2663: WHERE UC.csi_item_instance_id = CSI.instance_id AND
2664: UC.master_config_id = MC.mc_header_id AND
2665: UC.parent_uc_header_id IS NULL AND

Line 2678: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI

2674: -- Get UC header info
2675: CURSOR c_get_uc_header_info_csr(p_csi_item_instance_id NUMBER) IS
2676: SELECT UC.name,
2677: UC.unit_config_header_id
2678: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI
2679: WHERE UC.csi_item_instance_id IN
2680: (SELECT object_id
2681: FROM CSI_II_RELATIONSHIPS
2682: START WITH