[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'X'
FROM ahl_pc_associations
WHERE pc_node_id IN (
SELECT pc_node_id
FROM ahl_pc_nodes_b
START WITH pc_node_id = p_pc_node_id
CONNECT BY parent_node_id = PRIOR pc_node_id )
AND unit_item_id = p_inventory_id;
SELECT 'X'
FROM ahl_pc_associations
WHERE pc_node_id IN (
SELECT pc_node_id
FROM ahl_pc_nodes_b
CONNECT BY parent_node_id = PRIOR pc_node_id
START WITH pc_node_id = p_pc_node_id)
AND unit_item_id IN (
SELECT Unit_config_header_ID
FROM ahl_unit_header_details_v
WHERE Csi_Item_Instance_ID = p_Item_Instance_ID)
AND association_type_flag='U';
SELECT 'X'
FROM ahl_pc_associations
WHERE pc_node_id IN (
SELECT pc_node_id
FROM ahl_pc_nodes_b
CONNECT BY parent_node_id = PRIOR pc_node_id
START WITH pc_node_id = p_pc_node_id)
AND unit_item_id IN (
SELECT Unit_config_header_ID
FROM ahl_unit_config_headers
WHERE Csi_Item_Instance_ID = p_Item_Instance_ID
AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
AND association_type_flag='U';
SELECT 'X'
FROM ahl_pc_associations
WHERE pc_node_id IN (
SELECT pc_node_id
FROM ahl_pc_nodes_b
CONNECT BY parent_node_id = PRIOR pc_node_id
START WITH pc_node_id = p_pc_node_id)
AND unit_item_id in (
SELECT inventory_item_id
FROM csi_instance_details_v
WHERE Instance_ID = p_Item_Instance_ID)
AND association_type_flag='P';
SELECT 'X'
FROM ahl_pc_associations
WHERE pc_node_id IN (
SELECT pc_node_id
FROM ahl_pc_nodes_b
CONNECT BY parent_node_id = PRIOR pc_node_id
START WITH pc_node_id = p_pc_node_id)
AND unit_item_id in (
SELECT inventory_item_id
FROM csi_item_instances
WHERE Instance_ID = p_Item_Instance_ID)
AND association_type_flag='P';
select primary_flag, status, association_type_flag
from ahl_pc_headers_b
where pc_header_id = p_pc_header_id;
SELECT DISTINCT
MTL.INVENTORY_ITEM_ID
FROM
MTL_SYSTEM_ITEMS_KFV MTL,
MTL_ITEM_STATUS STAT,
AHL_PC_HEADERS_VL HEADER
WHERE
STAT.INVENTORY_ITEM_STATUS_CODE = MTL.INVENTORY_ITEM_STATUS_CODE AND
MTL.ITEM_TYPE = HEADER.PRODUCT_TYPE_CODE AND
MTL.ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID') AND
HEADER.PC_HEADER_ID = p_pc_header_id AND
MTL.INVENTORY_ITEM_STATUS_CODE NOT IN ('Obsolete','Inactive') AND
TRUNC(SYSDATE) BETWEEN NVL(TRUNC(MTL.START_DATE_ACTIVE), TRUNC(SYSDATE)) AND
NVL(TRUNC(MTL.END_DATE_ACTIVE), TRUNC(SYSDATE))
MINUS
SELECT DISTINCT
AHASS.UNIT_ITEM_ID
FROM
AHL_PC_ASSOCIATIONS_V AHASS,
AHL_PC_NODES_B NODE
WHERE
AHASS.ASSOCIATION_TYPE_FLAG = 'I' AND
AHASS.PC_NODE_ID = NODE.PC_NODE_ID AND
NODE.PC_HEADER_ID = p_pc_header_id;
SELECT DISTINCT
MTL.INVENTORY_ITEM_ID
FROM
MTL_SYSTEM_ITEMS_KFV MTL,
MTL_ITEM_STATUS STAT,
AHL_PC_HEADERS_B HEADER
WHERE
STAT.INVENTORY_ITEM_STATUS_CODE = MTL.INVENTORY_ITEM_STATUS_CODE AND
MTL.ITEM_TYPE = HEADER.PRODUCT_TYPE_CODE AND
-- SATHAPLI::Bug# 5576835, 17-Aug-2007
/*
MTL.ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID') AND
*/
MTL.ORGANIZATION_ID IN (SELECT DISTINCT MASTER_ORGANIZATION_ID FROM MTL_PARAMETERS) AND
HEADER.PC_HEADER_ID = p_pc_header_id AND
MTL.INVENTORY_ITEM_STATUS_CODE NOT IN ('Obsolete','Inactive') AND
TRUNC(SYSDATE) BETWEEN NVL(TRUNC(MTL.START_DATE_ACTIVE), TRUNC(SYSDATE)) AND
NVL(TRUNC(MTL.END_DATE_ACTIVE), TRUNC(SYSDATE))
MINUS
SELECT DISTINCT
AHS.UNIT_ITEM_ID
FROM
AHL_PC_ASSOCIATIONS AHS,
AHL_PC_NODES_B NODE
WHERE
AHS.ASSOCIATION_TYPE_FLAG = 'I' AND
AHS.PC_NODE_ID = NODE.PC_NODE_ID AND
NODE.PC_HEADER_ID = p_pc_header_id;
SELECT DISTINCT
UNIT.UNIT_CONFIG_HEADER_ID
FROM
AHL_UNIT_CONFIG_HEADERS UNIT,
CSI_ITEM_INSTANCES CSI,
MTL_SYSTEM_ITEMS_KFV MTL,
AHL_PC_HEADERS_B HEADER
WHERE
UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
CSI.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID AND
CSI.LAST_VLD_ORGANIZATION_ID = MTL.ORGANIZATION_ID AND
MTL.ITEM_TYPE = HEADER.PRODUCT_TYPE_CODE AND
UNIT.UNIT_CONFIG_STATUS_CODE IN ('COMPLETE', 'INCOMPLETE','QUARANTINE','DEACTIVATE_QUARANTINE') AND
HEADER.PC_HEADER_ID = p_pc_header_id AND
TRUNC(SYSDATE) BETWEEN NVL(TRUNC(UNIT.ACTIVE_START_DATE), TRUNC(SYSDATE)) AND
NVL(TRUNC(UNIT.ACTIVE_END_DATE), TRUNC(SYSDATE))
-- SATHAPLI::Bug#5140968 fix --
AND TRUNC(SYSDATE) < NVL(TRUNC(CSI.ACTIVE_END_DATE), TRUNC(SYSDATE + 1))
MINUS
SELECT
AHASS.UNIT_ITEM_ID
FROM
AHL_PC_ASSOCIATIONS_V AHASS,
AHL_PC_NODES_B NODE
WHERE
AHASS.ASSOCIATION_TYPE_FLAG = 'U' AND
AHASS.PC_NODE_ID = NODE.PC_NODE_ID AND
NODE.PC_HEADER_ID = p_pc_header_id;
SELECT DISTINCT
UNIT.UNIT_CONFIG_HEADER_ID
FROM
AHL_UNIT_CONFIG_HEADERS UNIT,
CSI_ITEM_INSTANCES CSI,
MTL_SYSTEM_ITEMS_KFV MTL,
AHL_PC_HEADERS_B HEADER
WHERE
UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND
CSI.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID AND
CSI.LAST_VLD_ORGANIZATION_ID = MTL.ORGANIZATION_ID AND
MTL.ITEM_TYPE = HEADER.PRODUCT_TYPE_CODE AND
UNIT.UNIT_CONFIG_STATUS_CODE IN ('COMPLETE',
'INCOMPLETE','QUARANTINE','DEACTIVATE_QUARANTINE') AND
HEADER.PC_HEADER_ID = p_pc_header_id AND
TRUNC(SYSDATE) BETWEEN NVL(TRUNC(UNIT.ACTIVE_START_DATE), TRUNC(SYSDATE))
AND
NVL(TRUNC(UNIT.ACTIVE_END_DATE), TRUNC(SYSDATE))
-- SATHAPLI::Bug#5140968 fix --
AND TRUNC(SYSDATE) < NVL(TRUNC(CSI.ACTIVE_END_DATE), TRUNC(SYSDATE + 1))
MINUS
SELECT
AHS.UNIT_ITEM_ID
FROM
AHL_PC_ASSOCIATIONS AHS,
AHL_PC_NODES_B NODE
WHERE
AHS.ASSOCIATION_TYPE_FLAG = 'U' AND
AHS.PC_NODE_ID = NODE.PC_NODE_ID AND
NODE.PC_HEADER_ID = p_pc_header_id;